|
|
PATSTSETUP FILE
Contains test setup information. Maintained primarily by PA49.1 (Employee
Tests).
REFERENCED BY
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.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 PA49.1
PA49.2 PA49.3 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA54.1 PA549 PA81.1 PA81.2
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8
UPDATED BY
PA48.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAP-COMPANY Numeric 4 PA48.1
Element: Company Hr
PAP-TEST Alpha 10 PA48.1
Element: Test Contains the test.
PAP-DESCRIPTION Alpha 30 (Lower Case) PA48.1
Element: Description Contains the test description.
PAP-WEB-DESC Alpha 15 (Lower Case) PA48.1
Element: Web Desc
PAP-WEB-AVAILABLE Alpha 1 PA48.1
Element: 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
Element: Web Avail SupvIndicates 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
Element: Active Flag Indicates whether the test is active or
inactive.
A = Active
I = Inactive
PAP-TEST-TYPE Alpha 10 PA48.1
Element: Test Type Contains the user-defined test type.
PAP-TEST-SOURCE Alpha 10 PA48.1
Element: Test Source Contains the user-defined test source.
PAP-EMP-APP Numeric 1 PA48.1
Element: Emp App Indicates whether the test applies to
employees, applicants, or both.
1 = Applicant
2 = Employee
3 = Applicant;Emp
PAP-RESULT-FL Alpha 1 PA48.1
Element: 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
Element: User Field1 Contains user-defined test information.
PAP-USER2 Alpha 10 PA48.1
Element: User2 Contains user-defined test information.
PAP-USER3 Alpha 10 PA48.1
Element: User3 Contains user-defined test information.
PAP-PREREQ-TEST Alpha 10 PA48.1
Element: Prereq Test Contains the test prerequisite.
PAP-REQ-FLAG Alpha 1 PA48.1
Element: Req Flag Indicates whether the test prerequisite
is required.
N = No
Y = Yes
PAP-PREREQ-RESULT1 Alpha 10 PA48.1
Element: Prereq Result1Contains the first result for the
prerequisite result range.
PAP-PREREQ-RESULT2 Alpha 10 PA48.1
Element: Prereq Result2Contains the second result for the
prerequisite result range.
PAP-PREREQ-FLAG Alpha 1 PA48.1
Element: 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
Element: 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
Element: Test Copy Indicates the test from which
eligibility criteria is copied.
PAP-GROUP-NAME Alpha 10 PA48.1
Element: Group Name Contains the employee group.
PAP-EMP-STATUS Alpha 2 Occurs 10 Times PA48.1
Element: Emp Status Contains the employee status.
PAP-POS-FLAG Alpha 1 PA48.1
Element: 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
Element: Date Measure Indicates the period in which the test
needs to be renewed.
PAP-UNIT-TYPE Alpha 1 PA48.1
Element: Unit Type Indicates the unit of measure for the
date measure.
1 = Days
2 = Months
3 = Years
PAP-RENEW-FLAG Alpha 1 PA48.1
Element: 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
Element: Renew Test Contains the renewal test name.
PAP-RESULT1 Alpha 10 PA48.1
Element: Result1 Contains the first result for the test.
PAP-RESULT2 Alpha 10 PA48.1
Element: Result2 Contains the second result for the test.
PAP-DATE-MEASURE2 Numeric 3 PA48.1
Element: Date Measure2 Indicates the time period during which
a follow up test must be taken.
PAP-DATE-MEASURE3 Numeric 3 PA48.1
Element: Date Measure3 Indicates the time period during which
the employee needs to complete the
prerequisite.
PAP-UNIT-TYPE2 Alpha 1 PA48.1
Element: 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
Element: 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
Element: Follow Up FlagIndicates 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
Element: Follow Test Contains the name of the follow up test.
PAP-LETTER Alpha 10 PA48.1
Element: Letter Contains the user-defined follow up
letter type.
PAP-TEST-LOCATION Alpha 10 PA48.1
Element: Test Location Contains the follow up test location.
PAP-EXP-COMPANY Numeric 4 PA48.1
Element: Company Contains the distribution expense
company to which the test costs should
be posted.
PAP-EXP-ACCT-UNIT Alpha 15 PA48.1
Element: Acct Unit Contains the expense accounting unit to
which the test costs should be posted.
PAP-EXP-ACCOUNT Numeric 6 PA48.1
Element: Account Contains the expense account to which
the test costs should be posted.
PAP-EXP-SUB-ACCT Numeric 4 PA48.1
Element: Sub Acct Contains the general ledger sub account
to which the test costs should be
posted.
PAP-COST Signed 11.2 PA48.1
Element: Cost Contains the test cost.
PAP-DATE-STAMP Numeric 8 (yyyymmdd) PA48.1
Element: 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
Element: 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
Element: User
PAP-CURRENCY-CODE Alpha 5 PA48.1
Element: Currency Code Contains the currency in which the test
cost is recorded.
PAP-CURR-ND Numeric 1 PA48.1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PAP-BASE-CURRENCY Alpha 5 PA48.1
Element: Base Currency Contains the company's base currency.
PAP-BASE-ND Numeric 1 PA48.1
Element: Base Nd The number of decimal positions defined
for the company base currency.
PAP-BASE-AMOUNT Signed 15.2 PA48.1
Element: Base Amt Contains the test cost in the company's
base currency.
PATSTSETUP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PAPSET1 COMPANY BN305 HAP3.1
TEST 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 PA49.1
...
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
|
