PATSTSETUP

Contains test setup information. Maintained primarily by PA49.1 (Employee Tests).

REFERENCED BY
PA349 PA49.1 PA49.2 PA49.3 PA81.1 PA81.2


UPDATED BY
PA48.1 BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1
HPQC.1 HPRS.1 HR00.1 HR01.1 HR11.1 HR11.2
HR511 HR54.1 HR55.1 HRS1.1 HRSC.1 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA149
PA248 PA249 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA54.1 PA549 PR110 PR113
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAP-COMPANY
Element: Company Hr		Numeric 4
PA48.1
PAP-TEST
Element: Test		Alpha 10
Contains the test.
PA48.1
PAP-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
Contains the test description.
PA48.1
PAP-WEB-DESC
Element: Web Desc		Alpha 15 (Lower Case)
PA48.1
PAP-WEB-AVAILABLE
Element: Web Available		Alpha 1
Indicates whether the test is available via the World Wide Web.
N = No
Y = Yes
PA48.1
PAP-WEB-AVAIL-SUPV
Element: Web Avail Supv		Alpha 1
Indicates whether the test is available to the employee's supervisor via the World Wide Web.
1 = Not Available
2 = Direct Supervisor
3 = Indirect Supervisor
4 = Direct;Indirect Supv
PA48.1
PAP-ACTIVE-FLAG
Element: Active Flag		Alpha 1
Indicates whether the test is active or inactive.
A = Active
I = Inactive
PA48.1
PAP-TEST-TYPE
Element: Test Type		Alpha 10
Contains the user-defined test type.
PA48.1
PAP-TEST-SOURCE
Element: Test Source		Alpha 10
Contains the user-defined test source.
PA48.1
PAP-EMP-APP
Element: Emp App		Numeric 1
Indicates whether the test applies to employees, applicants, or both.
1 = Applicant
2 = Employee
3 = Applicant;Emp
PA48.1
PAP-RESULT-FL
Element: Result Fl		Alpha 1
Indicates the type of results used for the test.
1 = None
2 = Positive;Negative
3 = Other
PA48.1
PAP-USER-FIELD-1
Element: User Field1		Alpha 30
Contains user-defined test information.
PA48.1
PAP-USER2
Element: User2		Alpha 10
Contains user-defined test information.
PA48.1
PAP-USER3
Element: User3		Alpha 10
Contains user-defined test information.
PA48.1
PAP-PREREQ-TEST
Element: Prereq Test		Alpha 10
Contains the test prerequisite.
PA48.1
PAP-REQ-FLAG
Element: Req Flag		Alpha 1
Indicates whether the test prerequisite is required.
N = No
Y = Yes
PA48.1
PAP-PREREQ-RESULT1
Element: Prereq Result1		Alpha 10
Contains the first result for the prerequisite result range.
PA48.1
PAP-PREREQ-RESULT2
Element: Prereq Result2		Alpha 10
Contains the second result for the prerequisite result range.
PA48.1
PAP-PREREQ-FLAG
Element: Prereq Flag		Alpha 1
Indicates whether the prerequisite period is measured by the date on which the perquisite test was schedule or the date on which the prerequisite test was completed.
1 = Schedule Date
2 = Status Date
PA48.1
PAP-ELIG-FLAG
Element: Elig Flag		Alpha 1
Indicates whether all employees or only specified employees are eligible for the test.
1 = All Paid Employees
2 = Specified Criteria
PA48.1
PAP-TEST-COPY
Element: Test Copy		Alpha 10
Indicates the test from which eligibility criteria is copied.
PA48.1
PAP-GROUP-NAME
Element: Group Name		Alpha 10
Contains the employee group.
PA48.1
PAP-EMP-STATUS
Element: Emp Status		Alpha 2 Occurs 10 Times
Contains the employee status.
PA48.1
PAP-POS-FLAG
Element: Pos Flag		Alpha 1
Indicates whether employees who hold specific positions or jobs are eligible for the test.
N = No
Y = Yes
PA48.1
PAP-DATE-MEASURE
Element: Date Measure		Numeric 3
Indicates the period in which the test needs to be renewed.
PA48.1
PAP-UNIT-TYPE
Element: Unit Type		Alpha 1
Indicates the unit of measure for the date measure.
1 = Days
2 = Months
3 = Years
PA48.1
PAP-RENEW-FLAG
Element: Renew Flag		Alpha 1
Indicates whether the renewal date is measured by the date on which the test is scheduled or by the date on which the test was completed.
1 = Schedule Date
2 = Status Date
PA48.1
PAP-RENEW-TEST
Element: Renew Test		Alpha 10
Contains the renewal test name.
PA48.1
PAP-RESULT1
Element: Result1		Alpha 10
Contains the first result for the test.
PA48.1
PAP-RESULT2
Element: Result2		Alpha 10
Contains the second result for the test.
PA48.1
PAP-DATE-MEASURE2
Element: Date Measure2		Numeric 3
Indicates the time period during which a follow up test must be taken.
PA48.1
PAP-DATE-MEASURE3
Element: Date Measure3		Numeric 3
Indicates the time period during which the employee needs to complete the prerequisite.
PA48.1
PAP-UNIT-TYPE2
Element: Unit Type2		Alpha 1
Indicates the unit of measure for the date measure 2.
1 = Days
2 = Months
3 = Years
PA48.1
PAP-UNIT-TYPE3
Element: Unit Type3		Alpha 1
Indicates the unit of measure for the date measure 3.
1 = Days
2 = Months
3 = Years
PA48.1
PAP-FOLLOW-UP-FLAG
Element: Follow Up Flag		Alpha 1
Indicates whether the follow up period is measured from the date on which the test is scheduled or the date on which the test is completed.
1 = Schedule Date
2 = Status Date
PA48.1
PAP-FOLLOW-TEST
Element: Follow Test		Alpha 10
Contains the name of the follow up test.
PA48.1
PAP-LETTER
Element: Letter		Alpha 10
Contains the user-defined follow up letter type.
PA48.1
PAP-TEST-LOCATION
Element: Test Location		Alpha 10
Contains the follow up test location.
PA48.1
PAP-EXP-COMPANY
Element: Company		Numeric 4
Contains the distribution expense company to which the test costs should be posted.
PA48.1
PAP-EXP-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the expense accounting unit to which the test costs should be posted.
PA48.1
PAP-EXP-ACCOUNT
Element: Account		Numeric 6
Contains the expense account to which the test costs should be posted.
PA48.1
PAP-EXP-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the general ledger sub account to which the test costs should be posted.
PA48.1
PAP-COST
Element: Cost		Signed 11.2
Contains the test cost.
PA48.1
PAP-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
PA48.1
PAP-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA48.1
PAP-USER-ID
Element: User		Alpha 10 (Lower Case)
PA48.1
PAP-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the test cost is recorded.
PA48.1
PAP-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA48.1
PAP-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company's base currency.
PA48.1
PAP-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
PA48.1
PAP-BASE-AMOUNT
Element: Base Amt		Signed 15.2
Contains the test cost in the company's base currency.
PA48.1


PATSTSETUP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAPSET1 COMPANY
TEST
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR511
HR54.1 HR55.1
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA149 PA248
PA249 PA349
PA48.1 PA48.2
PA48.3 PA48.4


PATSTSETUP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (PAP-CURRENCY-CODE !=Spaces )
PAP-BASE-CURRENCY->CUC-CURRENCY-CODE
Company PRSYSTEM Required
PAP-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (PAP-CURRENCY-CODE !=Spaces )
PAP-CURRENCY-CODE->CUC-CURRENCY-CODE
Exp Account GLMASTER Required
When (PAP-EXP-ACCOUNT !=Zeroes )
PAP-EXP-COMPANY->GLM-COMPANY
PAP-EXP-ACCT-UNIT->GLM-ACCT-UNIT
PAP-EXP-ACCOUNT->GLM-ACCOUNT
PAP-EXP-SUB-ACCT->GLM-SUB-ACCOUNT
Follow Test PATSTSETUP Required
When (PAP-FOLLOW-TEST !=Spaces )
PAP-COMPANY->PAP-COMPANY
PAP-FOLLOW-TEST->PAP-TEST
Group PERSGROUP Required
When (PAP-GROUP-NAME !=Spaces )
PAP-COMPANY->PRG-COMPANY
PAP-GROUP-NAME->PRG-GROUP-NAME
Prereq Result1 PATSTRESLT Required
When (PAP-PREREQ-RESULT1 !=Spaces )
PAP-COMPANY->PTR-COMPANY
PAP-PREREQ-TEST->PTR-TEST
PAP-PREREQ-RESULT1->PTR-CODE
Prereq Result2 PATSTRESLT Required
When (PAP-PREREQ-RESULT2 !=Spaces )
PAP-COMPANY->PTR-COMPANY
PAP-PREREQ-TEST->PTR-TEST
PAP-PREREQ-RESULT2->PTR-CODE
Prereq Test PATSTSETUP Required
When (PAP-PREREQ-TEST !=Spaces )
PAP-COMPANY->PAP-COMPANY
PAP-PREREQ-TEST->PAP-TEST
Renew Test PATSTSETUP Required
When (PAP-RENEW-TEST !=Spaces )
PAP-COMPANY->PAP-COMPANY
PAP-RENEW-TEST->PAP-TEST
Result1 PATSTRESLT Required
When (PAP-RESULT1 !=Spaces )
PAP-COMPANY->PTR-COMPANY
PAP-TEST->PTR-TEST
PAP-RESULT1->PTR-CODE
Result2 PATSTRESLT Required
When (PAP-RESULT2 !=Spaces )
PAP-COMPANY->PTR-COMPANY
PAP-TEST->PTR-TEST
PAP-RESULT2->PTR-CODE
Test Copy PATSTSETUP Required
When (PAP-TEST-COPY !=Spaces )
PAP-COMPANY->PAP-COMPANY
PAP-TEST-COPY->PAP-TEST
Test Letter PCODES Required
When (PAP-LETTER !=Spaces )
"TL"->PCO-TYPE
PAP-LETTER->PCO-CODE
Test Location PCODES Required
When (PAP-TEST-LOCATION !=Spaces )
"TO"->PCO-TYPE
PAP-TEST-LOCATION->PCO-CODE
Test Source PCODES Required
When (PAP-TEST-SOURCE !=Spaces )
"TS"->PCO-TYPE
PAP-TEST-SOURCE->PCO-CODE
Test Type PCODES Required
When (PAP-TEST-TYPE !=Spaces )
"TT"->PCO-TYPE
PAP-TEST-TYPE->PCO-CODE


PATSTSETUP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicants PAEMPAPTST
PAP-COMPANY->PTS-COMPANY
PAP-TEST->PTS-TEST
1->PTS-EMP-APP
  PTS-EMPLOYEE
  PTS-SEQ-NBR
Employees PAEMPAPTST
PAP-COMPANY->PTS-COMPANY
PAP-TEST->PTS-TEST
Zeroes->PTS-EMP-APP
  PTS-EMPLOYEE
  PTS-SEQ-NBR
Override PATESTOVER
PAP-COMPANY->PAV-COMPANY
PAP-TEST->PAV-TEST
  PAV-EMPLOYEE
Pos Job Req JOBRELATE
PAP-COMPANY->JBR-COMPANY
Spaces->JBR-PROCESS-LEVEL
"TS"->JBR-TYPE
PAP-TEST->JBR-PERS-CODE
  JBR-SUBJECT-CODE
  JBR-JOB-CODE
  JBR-POSITION
Results PATSTRESLT
PAP-COMPANY->PTR-COMPANY
PAP-TEST->PTR-TEST
  PTR-CODE

File created: Wed Jun 08 20:50:27 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.