PATSTSETUP

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

REFERENCED BY
BN305 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR11.4 HR28.1 HR511
HR54.1 HR55.1 HRS1.1 HRSC.1 LT101 LT111
ZH510 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 PR12.6 PR120 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 PR30.2 PR512


UPDATED BY
PA48.1 HR00.1 HR01.1

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 HR11.4
HR28.1 HR511
HR54.1 HR55.1
HRS1.1 HRSC.1
LT101 LT111
ZH510 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA149
PA248 PA249


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: Thu Jun 09 02:25:09 2016

Home
Contact Us



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