PATSTSETUP FILE
Contains test setup information. Maintained primarily by PA49.1 (Employee
Tests).
REFERENCED BY
HR54.1 HR55.1 HRS1.1 HRSC.1 PA149 PA248
PA249 PA349 PA49.1 PA49.2 PA49.3 PA54.1
PA549 PA81.1 PA81.2
UPDATED BY
PA48.1 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAP-COMPANY Numeric 4 PA48.1
Company The company number represents an
established company and is entered on
all function codes.
PAP-TEST Alpha 10 PA48.1
Test Contains the test.
PAP-DESCRIPTION Alpha 30 (Lower Case) PA48.1
Description Contains the test description.
PAP-WEB-DESC Alpha 15 (Lower Case) PA48.1
Web Desc
PAP-WEB-AVAILABLE Alpha 1 PA48.1
Web Available Indicates whether the test is available
via the World Wide Web.
N = No
Y = Yes
PAP-WEB-AVAIL-SUPV Alpha 1 PA48.1
Web Avail Supv 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
PAP-ACTIVE-FLAG Alpha 1 PA48.1
Status Indicates whether the test is active or
inactive.
A = Active
I = Inactive
PAP-TEST-TYPE Alpha 10 PA48.1
Test Type Contains the user-defined test type.
PAP-TEST-SOURCE Alpha 10 PA48.1
Test Source Contains the user-defined test source.
PAP-EMP-APP Numeric 1 PA48.1
Type Indicates whether the test applies to
employees, applicants, or both.
1 = Applicant
2 = Employee
3 = Applicant;Emp
PAP-RESULT-FL Alpha 1 PA48.1
Result Fl Indicates the type of results used for
the test.
1 = None
2 = Positive;Negative
3 = Other
PAP-USER-FIELD-1 Alpha 30 PA48.1
User Field 1 Contains user-defined test information.
PAP-USER2 Alpha 10 PA48.1
User2 Contains user-defined test information.
PAP-USER3 Alpha 10 PA48.1
User3 Contains user-defined test information.
PAP-PREREQ-TEST Alpha 10 PA48.1
Prereq Test Contains the test prerequisite.
PAP-REQ-FLAG Alpha 1 PA48.1
Req Flag Indicates whether the test prerequisite
is required.
N = No
Y = Yes
PAP-PREREQ-RESULT1 Alpha 10 PA48.1
Prereq Result1 Contains the first result for the
prerequisite result range.
PAP-PREREQ-RESULT2 Alpha 10 PA48.1
Prereq Result2 Contains the second result for the
prerequisite result range.
PAP-PREREQ-FLAG Alpha 1 PA48.1
Prereq Flag 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
PAP-ELIG-FLAG Alpha 1 PA48.1
Elig Flag Indicates whether all employees or only
specified employees are eligible for the
test.
1 = All Paid Employees
2 = Specified Criteria
PAP-TEST-COPY Alpha 10 PA48.1
Test Copy Indicates the test from which
eligibility criteria is copied.
PAP-GROUP-NAME Alpha 10 PA48.1
Group Name Contains the employee group.
PAP-EMP-STATUS Alpha 2 Occurs 10 Times PA48.1
Employee Status Contains the employee status.
PAP-POS-FLAG Alpha 1 PA48.1
Pos Flag Indicates whether employees who hold
specific positions or jobs are eligible
for the test.
N = No
Y = Yes
PAP-DATE-MEASURE Numeric 3 PA48.1
Date Measure Indicates the period in which the test
needs to be renewed.
PAP-UNIT-TYPE Alpha 1 PA48.1
EEO Unit Type Indicates the unit of measure for the
date measure.
1 = Days
2 = Months
3 = Years
PAP-RENEW-FLAG Alpha 1 PA48.1
Renew Flag 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
PAP-RENEW-TEST Alpha 10 PA48.1
Renew Test Contains the renewal test name.
PAP-RESULT1 Alpha 10 PA48.1
Result1 Contains the first result for the test.
PAP-RESULT2 Alpha 10 PA48.1
Result2 Contains the second result for the test.
PAP-DATE-MEASURE2 Numeric 3 PA48.1
Date Measure2 Indicates the time period during which
a follow up test must be taken.
PAP-DATE-MEASURE3 Numeric 3 PA48.1
Date Measure3 Indicates the time period during which
the employee needs to complete the
prerequisite.
PAP-UNIT-TYPE2 Alpha 1 PA48.1
Unit Type2 Indicates the unit of measure for the
date measure 2.
1 = Days
2 = Months
3 = Years
PAP-UNIT-TYPE3 Alpha 1 PA48.1
Unit Type3 Indicates the unit of measure for the
date measure 3.
1 = Days
2 = Months
3 = Years
PAP-FOLLOW-UP-FLAG Alpha 1 PA48.1
Follow Up Flag 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
PAP-FOLLOW-TEST Alpha 10 PA48.1
Follow Test Contains the name of the follow up test.
PAP-LETTER Alpha 10 PA48.1
Letter Contains the user-defined follow up
letter type.
PAP-TEST-LOCATION Alpha 10 PA48.1
Test Location Contains the follow up test location.
PAP-EXP-COMPANY Numeric 4 PA48.1
Exp Company Contains the distribution expense
company to which the test costs should
be posted.
PAP-EXP-ACCT-UNIT Alpha 15 PA48.1
Expense Accounting Contains the expense accounting unit to
Unit which the test costs should be posted.
PAP-EXP-ACCOUNT Numeric 6 PA48.1
Expense Account Contains the expense account to which
the test costs should be posted.
PAP-EXP-SUB-ACCT Numeric 4 PA48.1
Depr Expense Contains the general ledger sub account
Subaccount to which the test costs should be
posted.
PAP-COST Signed 11.2 PA48.1
Cost Contains the test cost.
PAP-DATE-STAMP Numeric 8 (yyyymmdd) PA48.1
Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PAP-TIME-STAMP Numeric 6 (hhmmss) PA48.1
Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PAP-USER-ID Alpha 10 (Lower Case) PA48.1
User ID Name Contains the user ID of the person who
last changed this record.
PAP-CURRENCY-CODE Alpha 5 PA48.1
Currency Code Contains the currency in which the test
cost is recorded.
PAP-CURR-ND Numeric 1 PA48.1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PAP-BASE-CURRENCY Alpha 5 PA48.1
Base Currency Contains the company's base currency.
PAP-BASE-ND Numeric 1 PA48.1
Base Number Of The number of decimal positions defined
Decimals for the company base currency.
PAP-BASE-AMOUNT Signed 15.2 PA48.1
Base Amount Contains the test cost in the company's
base currency.
PATSTSETUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAPSET1 COMPANY HR00.1 HR01.1
TEST HR54.1 HR55.1
HRS1.1 HRSC.1
PA149 PA248
PA249 PA349
PA48.1 PA48.2
PA48.3 PA48.4
PA49.1 PA49.2
PA49.3 PA54.1
PA549 PA81.1
PA81.2 PR197
PATSTSETUP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
