|
|
APPLICANT FILE
Applicant
The Applicant file contains information on applicants.
REFERENCED BY
BN305 HAP3.1 HAPL.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR00.1 HR01.1 HR11.1 HR11.2 HR15.1
HR170 HR21.1 HR30.1 HR511 HR515 HR54.1
HR70.1 HREF.1 HRS1.1 HRSC.1 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS50.1 HS50.2
HS50.5 HS51.1 HS51.2 HS52.1 HS52.2 PA02.1
PA102 PA115 PA13.1 PA13.2 PA135 PA149
PA19.1 PA231 PA232 PA233 PA234 PA235
PA236 PA238 PA239 PA240 PA241 PA242
PA243 PA244 PA248 PA249 PA262 PA263
PA272 PA33.1 PA349 PA37.1 PA43.1 PA43.2
PA44.1 PA45.1 PA49.1 PA49.3 PA502 PA513
PA53.1 PA533 PA54.1 PA549 PA62.1 PA63.1
PA64.1 PA64.2 PA65.1 PA65.2 TR120 TR121
TR20.1 TR20.2 TR20.3 TR22.1 TR500 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
HAP2.1 PA534
UPDATED BY
HR90.1 PA100 PA120 PA20.1 PA21.1 PA22.1
PA24.1 PA27.1 PA31.1 PA32.1 PA34.1 PA35.1
PA36.1 PA38.1 PA39.1 PA40.1 PA41.1 PA52.4
PA520 PA531 TR21.1 TR26.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APL-COMPANY Numeric 4 PA31.1 PA39.1
Element: Company Contains the company number which PA40.1 PA531
represents an established company.
APL-APPLICANT Numeric 9 PA31.1 PA39.1
Element: Applicant Contains the applicant's number. The PA40.1 PA531
number correlates all information about
the applicant.
APL-LAST-NAME Alpha 30 (Lower Case) PA31.1 PA43.1
Element: Last Name Contains the applicant's last name. PA531
APL-FIRST-NAME Alpha 15 (Lower Case) PA31.1 PA43.1
Element: First Name Contains the applicant's first name. PA531
APL-MIDDLE-NAME Alpha 15 (Lower Case) PA31.1 PA531
Element: Middle Name Contains the applicant's middle name.
APL-MIDDLE-INIT Alpha 1 PA31.1 PA43.1
Element: Middle InitialContains the applicant's middle initial. PA531
APL-NICK-NAME Alpha 30 (Lower Case) PA31.1 PA531
Element: Nick Name Contains the applicant's nickname.
APL-ADDR1 Alpha 30 (Lower Case) PA31.1 PA531
Element: Address 1 Contains the first line of the
applicant's address.
APL-ADDR2 Alpha 30 (Lower Case) PA31.1 PA531
Element: Address 2 Contains the second line of the
applicant's address.
APL-ADDR3 Alpha 30 (Lower Case) PA31.1 PA531
Element: Address 3 Contains the third line of the
applicant's address.
APL-ADDR4 Alpha 30 (Lower Case) PA31.1 PA531
Element: Address 4 Contains the fourth line of the
applicant's address.
APL-CITY Alpha 18 (Lower Case) PA31.1 PA531
Element: City Contains the city of the applicant's
address.
APL-STATE Alpha 2 PA31.1 PA531
Element: State or ProviContains the state of the applicant's
address.
APL-ZIP Alpha 10 PA31.1 PA531
Element: Postal Code Contains the postal code of the
applicant's address.
APL-HM-PHONE-CNTRY Alpha 6 PA31.1 PA531
Home Phone Country Contains the prefix of the applicant's
Code home telephone.
APL-HM-PHONE-NBR Alpha 15 PA31.1 PA531
Element: Home Phone NumContains the applicant's home telephone
number.
APL-WK-PHONE-CNTRY Alpha 6 PA31.1 PA531
Work Phone Country Contains the prefix of the applicant's
Code work telephone number.
APL-WK-PHONE-NBR Alpha 15 PA31.1 PA531
Element: Work Phone NumContains the applicant's work telephone
number.
APL-WK-PHONE-EXT Alpha 5 PA31.1 PA531
Element: Work Phone ExtContains the extension of the
applicant's work telephone number.
APL-FAX-COUNTRY Alpha 6 PA31.1 PA531
Element: Fax Country CoContains the prefix of the fax number.
For example, the country or city code.
APL-FAX-NBR Alpha 15 PA31.1 PA531
Element: Fax Number Contains the applicant's fax telephone
number.
APL-FAX-EXT Alpha 5 PA31.1 PA531
Element: Fax Extension This field contains the telephone
extension number.
APL-DATE-HIRED Numeric 8 (yyyymmdd) PA100 PA31.1
Element: Hire Date Contains the date the applicant was PA52.4 PA531
hired.
APL-APP-STATUS Alpha 2 PA31.1 PA531
Element: Applicant StatContains the applicant's status.
APL-FICA-NBR Alpha 20 PA31.1 PA531
Element: Social Number Contains the applicant's Social
Security number.
APL-DATE-APPLIED Numeric 8 (yyyymmdd) PA31.1 PA531
Element: Date Applied Contains the date the applicant applied.
APL-HIRE-SOURCE Alpha 10 PA31.1 PA531
Element: Hire Source Indicates how the applicant found out
about job. This must be valid in the
Human Resource Codes file.
APL-REF-LST-NAME Alpha 30 (Lower Case) PA31.1 PA531
Referred By Last Contains the last name of the employee
Name who referred the applicant.
APL-REF-FST-NAME Alpha 15 (Lower Case) PA31.1 PA531
Referred By First Contains the first name of the employee
Name who referred the applicant.
APL-REF-MID-INIT Alpha 1 PA31.1 PA531
Referred By Middle Contains the middle initial of the
Initial employee who referred the applicant.
APL-FINDERS-FEE Numeric 10 PA31.1 PA531
Element: Finders Fee Contains the finders fee.
APL-PREV-APPLY Alpha 1 PA31.1 PA531
Element: Previously AppIndicates whether the applicant
previously applied with company.
N = No
Y = Yes
APL-PREV-LOCATION Alpha 30 (Lower Case) PA31.1 PA531
Element: Where Contains the location to which the
applicant previously applied.
APL-PREV-DATE Numeric 8 (yyyymmdd) PA31.1 PA531
Element: When Contains the date the applicant
previously applied.
APL-PREV-EMPLOY Alpha 1 PA31.1 PA531
Element: Previously EmpIndicates whether the applicant
previously worked for the company.
N = No
Y = Yes
APL-PREV-EMP-NBR Numeric 9 PA31.1 PA531
Element: Employee NumbeContains the applicant's previous
employee number.
APL-PREV-LOC-WORK Alpha 30 (Lower Case) PA31.1 PA531
Element: Where Contains the applicant's previous work
location.
APL-PREV-BEG-DATE Numeric 8 (yyyymmdd) PA31.1 PA531
Element: When - Begin DContains the beginning date of the
applicant's previous employment.
APL-PREV-END-DATE Numeric 8 (yyyymmdd) PA31.1 PA531
Element: When - End DatContains the ending date of the
applicant's previous employment.
APL-RATING Alpha 10 PA31.1 PA531
Element: Rating Contains applicant rating codes.
APL-FORMER-LST-NM Alpha 30 (Lower Case) PA31.1 PA531
Element: Former Last NaContains the former last name of the
applicant.
APL-FORMER-FST-NM Alpha 15 (Lower Case) PA31.1 PA531
Element: Former First NContains the former first name of the
applicant.
APL-FORMER-MI Alpha 1 PA31.1 PA531
Former Middle Contains the former middle initial of
Initial the applicant.
APL-PREV-ADDR1 Alpha 30 (Lower Case) PA31.1 PA531
Element: Previous AddreContains the first line of the
applicant's previous address.
APL-PREV-ADDR2 Alpha 30 (Lower Case) PA31.1 PA531
Element: Previous AddreContains the second line of the
applicant's previous address.
APL-PREV-ADDR3 Alpha 30 (Lower Case) PA31.1 PA531
Element: Previous AddreContains the third line of the
applicant's previous address.
APL-PREV-ADDR4 Alpha 30 (Lower Case) PA31.1 PA531
Element: Previous AddreContains the fourth line of the
applicant's previous address.
APL-PREV-CITY Alpha 18 (Lower Case) PA31.1 PA531
Element: City Contains the city of the applicant's
previous address.
APL-PREV-STATE Alpha 2 PA31.1 PA531
Element: State or ProviContains the state of the applicant's
previous address.
APL-PREV-ZIP Alpha 10 PA31.1 PA531
Element: Postal Code Contains the postal code of the
applicant's previous address.
APL-PREV-CNTRY-CD Alpha 2 PA31.1 PA531
Element: Prev Cntry Cd Contains the country code for the
applicant's previous address.
APL-EEO-CLASS Alpha 4 (Lower Case) PA31.1 PA531
Element: EEO Class Contains the applicant's EEO-class.
APL-SEX Alpha 1 PA31.1 PA531
Element: Gender Contains the applicant's sex.
F = Female
M = Male
X = Not Disclosed
APL-AGE-FLAG Alpha 1 PA31.1 PA531
Element: Age Indicates whether the applicant is
between the ages of 18 and 70.
Y = Yes
N = No
APL-HANDICAP-ID Alpha 1 PA31.1 PA531
Element: Disability Indicates whether the applicant is
disabled.
Y = Yes
N = No
X = Not Disclosed
APL-JOB1 Alpha 9 PA31.1 PA531
Element: Primary Job CoContains the job code of the
applicant's first job choice.
APL-JOB2 Alpha 9 PA31.1 PA531
Element: Secondary Job Contains the job code of the
applicant's second job choice.
APL-JOB3 Alpha 9 PA31.1 PA531
Element: Tertiary Job CContains the job code of the
applicant's third job choice.
APL-BEG-PAY Signed 11.2 PA31.1 PA531
Element: Beginning Pay Contains the minimum expected pay.
APL-END-PAY Signed 11.2 PA31.1 PA531
Element: Ending Pay Contains the maximum expected pay.
APL-DATE-AVAIL Numeric 8 (yyyymmdd) PA31.1 PA531
Element: Date AvailableContains the date the applicant is
available to begin work.
APL-VETERAN Alpha 4 PA31.1 PA531
Element: Veteran Indicates whether the applicant is a
veteran.
APL-DRAFT-STATUS Alpha 3 PA31.1 PA39.1
Bill of Exchange Contains the user-defined draft status. PA531
Status
APL-FINAL-RANK Alpha 3 PA31.1 PA39.1
Element: Final MilitaryContains the applicant's final military PA531
rank.
APL-CUR-STATUS Alpha 2 PA31.1 PA39.1
Element: Current StatusIndicates the applicant's current PA531
military status.
NG = National Guard
RE = Reserves
APL-LAST-PHYSICAL Numeric 8 (yyyymmdd) PA31.1 PA40.1
Element: Last Physical Contains the date of the last physical PA531
examination.
APL-WK-RST-CODE1 Alpha 10 PA31.1 PA40.1
Work Restriction Contains the first work restriction PA531
Code 1 code for the applicant.
APL-WK-RST-CODE2 Alpha 10 PA31.1 PA40.1
Work Restriction Contains the second work restriction PA531
Code 2 code for the applicant.
APL-WK-RST-CODE3 Alpha 10 PA31.1 PA40.1
Work Restriction Contains the third work restriction PA531
Code 3 code for the applicant.
APL-WK-RST-CODE4 Alpha 10 PA31.1 PA40.1
Work Restriction Contains the fourth work restriction PA531
Code 4 code for the applicant.
APL-RESUME Alpha 1 PA31.1 PA531
Element: Resume ReceiveIndicates whether the applicant's
resume has been received.
Y = Yes
N = No
APL-LAST-COM-SEQ Numeric 4 HR90.1 PA31.1
Last Comment Contains the last sequence number used PA531
Sequence Number for the Personnel Comments file.
APL-LAST-REF-SEQ Numeric 4 PA31.1 PA32.1
Last Reference Contains the last sequence number used PA531
Sequence Nmbr for references.
APL-LAST-INT-SEQ Numeric 4 PA31.1 PA41.1
Last Interview Contains the last sequence number used PA531
Sequence Number for interviews.
APL-LAST-MIL-SEQ Numeric 4 PA31.1 PA39.1
Last Military Contains the last sequence number used PA531
Sequence Number for military service record.
APL-LAST-EPC-SEQ Numeric 4 PA20.1 PA21.1
Last Emp Code Contains the last sequence number used PA22.1 PA24.1
Sequence Number for employee codes. PA27.1 PA31.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA531
TR21.1 TR26.1
APL-POSITION1 Alpha 12 PA31.1 PA531
Primary Position Contains the first position in which
Number the applicant is interested.
APL-POSITION2 Alpha 12 PA31.1 PA531
Secondary Position Contains the second position in which
Number the applicant is interested.
APL-POSITION3 Alpha 12 PA31.1 PA531
Tertiary Position Contains the third position in which
Number the applicant is interested.
APL-PROCESS-LEVEL Alpha 5 PA31.1 PA531
Element: Process Level Contains the process level the
applicant is associated with.
APL-EMP-STATUS Alpha 2 PA31.1 PA531
Element: Employee StatuContains the employee status that
indicates whether the applicant wants to
work full-time, part-time, seasonal,
temporary, and so on.
APL-WORK-SCHED Alpha 10 PA31.1 PA531
Element: Work Schedule Contains the work schedule that
indicates when the applicant wants to
work.
APL-SEC-LVL Numeric 1 PA31.1 PA531
Element: Security LevelThis field is not used. It is for
future security enhancements.
APL-SEC-LOCATION Alpha 10 PA31.1 PA531
Element: Security LocatThis field is not used. It is for
future security enhancements.
APL-NBR-FTE Signed 7.6 PA31.1 PA531
Full Time Contains the FTE (Full-Time
Equivalent Number Equivalency) factor that indicates the
percent of annual hours the applicant
wants to work. For example, if the
applicant wants to work full-time, this
field is 1.
APL-PIN Alpha 10 (Lower Case) PA31.1 PA531
Element: Pin Contains the applicant personal ID
number. This is used for Employee
Self-Service.
APL-ELIG-WORK Alpha 1 PA31.1 PA531
Element: Elig Work Indicates whether the applicant is
eligible to work in the United States.
Y = Yes
N = No
APL-TRAV-AVAIL Alpha 1 PA31.1 PA531
Element: Trav Avail Indicates whether the applicant is
available for travel.
Y = Yes
N = No
APL-TRAV-PCT Numeric 3 PA31.1 PA531
Element: Trav Pct Indicates the percentage the applicant
is available for travel.
APL-RELOC-AVAIL Alpha 1 PA31.1 PA531
Element: Reloc Avail Indicates whether the applicant is
available for relocation.
Y = Yes
N = No
APL-OT-AVAIL Alpha 1 PA31.1 PA531
Element: Ot Avail Indicates whether the applicant is
available for overtime.
Y = Yes
N = No
APL-EMAIL-ADDRESS Alpha 60 (Lower Case) PA31.1 PA531
Element: Email Address Contains the applicant's email address.
APL-DATE-STAMP Numeric 8 (yyyymmdd) PA31.1 PA531
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
APL-TIME-STAMP Numeric 6 (hhmmss) PA31.1 PA531
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
APL-USER-ID Alpha 10 (Lower Case) PA31.1 PA531
Element: User
APL-EMPLOYEE Numeric 9 PA100 PA31.1
Element: Employee Contains the name of the employee to PA52.4 PA531
contact when the applicant is hired.
APL-CURRENCY-CODE Alpha 5 PA31.1 PA531
Element: Currency Code Contains the currency in which the pay
is recorded.
APL-CURR-ND Numeric 1 PA31.1 PA531
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
APL-COUNTRY-CODE Alpha 2 PA31.1 PA531
Element: Country Code Contains the country of the applicant's
address.
APL-BIRTHDATE Numeric 8 (yyyymmdd) PA31.1 PA531
Element: Birthdate Contains the applicant's birth date.
APL-LANGUAGE-CODE Alpha 10 PA31.1 PA531
Element: Language Code Contains the applicant's language, if
other than the company's default
language.
APL-NAME-PREFIX Alpha 4 (Lower Case) PA31.1 PA531
Element: Name Prefix Contains the applicant's title.
APL-NAME-SUFFIX Alpha 4 (Lower Case) PA31.1 PA531
Element: Name Suffix Contains the applicant's name suffix.
APL-DISABILITY Alpha 10 PA31.1 PA531
Element: Disability Indicates the type of disability the
applicant has.
APL-BASE-BEG-PAY Signed 11.2 PA31.1 PA531
Element: Salary Contains the applicant's beginning pay
(of the previous job) in the company's
base currency.
APL-BASE-END-PAY Signed 11.2 PA31.1 PA531
Element: Salary Contains the applicant's ending pay (of
previous job) in the company's base
currency.
APL-BASE-CURRENCY Alpha 5 PA31.1 PA531
Element: Base Currency Contains the company base currency.
APL-BASE-ND Numeric 1 PA31.1 PA531
Element: Base Nd The number of decimal positions defined
for the company base currency.
APL-BASE-FEE Numeric 10 PA31.1 PA531
Element: Base Fee Contains the finder's fee in the
company's base currency.
APL-CURR-CODE-2 Alpha 5 PA31.1 PA531
Element: Curr Code 2 Contains the currency in which the
finder's fee is recorded.
APL-CURR-CODE-ND-2 Numeric 1 PA31.1 PA531
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
APL-RELIGION Alpha 10 PA31.1 PA531
Element: Religion Contains the applicant's religion.
APL-LAST-NAME-PRE Alpha 30 (Lower Case) PA31.1 PA531
Element: Last Name Pre
APL-CONSENT Alpha 1 PA31.1 PA531
Element: Consent N = No
Y = Yes
" " = No
APL-LAST-PRE Derived
Element: Last Pre
APL-LAST-SUF Derived
Element: Last Suf
APL-LAST-PRE-SUF Derived
Element: Last Pre Suf
APL-LAST-NAME-EXP Derived
Element: Last Name Exp
APL-FIRST-MI Derived
Element: First Mi
APL-FIRST-MI-EXP Derived
Element: First Mi Exp
APL-LABEL-NAME Derived
Element: Label Name Contains the applicant's name, as it
should appear on labels.
APL-LABEL-ADDR Derived
Element: Label Addr Contains the applicants address as it
should appear on labels.
APL-FULL-NAME Derived
Element: Full Name Contains the applicant's full name.
APL-SHORT-NAME Derived
Element: Short Name Contains the applicant's short name.
APL-COUNTY Alpha 25 (Lower Case)
Element: County The county for the company address.
APL-LABEL-NAME-1 Derived
Element: Label Name 1
APL-SUPP-ADDR1 Alpha 30 (Lower Case)
Element: Supp Addr1
APL-SUPP-ADDR2 Alpha 30 (Lower Case)
Element: Supp Addr2
APL-SUPP-ADDR3 Alpha 30 (Lower Case)
Element: Supp Addr3
APL-SUPP-ADDR4 Alpha 30 (Lower Case)
Element: Supp Addr4
APL-SUPP-CITY Alpha 18 (Lower Case)
Element: Supp City
APL-SUPP-STATE Alpha 2
Element: Supp State
APL-SUPP-ZIP Alpha 10
Element: Supp Zip
APL-SUPP-CNTRY-CD Alpha 2
Element: Supp Cntry Cd
APL-SUPP-PHONE-CNT Alpha 6
Element: Supp Phone Cnt
APL-SUPP-PHONE-NBR Alpha 15
Element: Supp Phone Nbr
APL-REQ-FILLED Numeric 9
Element: Req Filled
APL-POS-FILLED Alpha 12
Element: Pos Filled
APL-JOB-FILLED Alpha 9
Element: Job Filled
APL-HIRED-PAY-RATE Signed 13.4
Element: Hired Pay Rate
APL-SUPERVISOR Alpha 10
Element: Supervisor
APL-NBR-FTE-HIRED Signed 7.6
Element: Nbr Fte Hired
APL-BIRTH-CITY Alpha 18 (Lower Case)
Element: Birth City
APL-BIRTH-STATE Alpha 2
Element: Birth State
APL-BIRTH-CNTRY-CD Alpha 2
Element: Birth Cntry Cd
APL-VISIBLE-MIN Alpha 1
Element: Visible Min N = No
Y = Yes
APL-ABORIGINAL Alpha 1
Element: Aboriginal N = No
Y = Yes
APL-DEPARTMENT Alpha 5
Element: Department Contains the department.
APL-UNION-CODE Alpha 10
Element: Union Code
APL-BARGAIN-UNIT Alpha 10
Element: Bargain Unit
APL-SUPERVISOR-IND Alpha 10
Element: Supervisor
APL-I9-STATUS Alpha 10
Element: I9 Status
APL-I9-ALIEN-NBR Alpha 11
Element: I9 Alien Nbr
APL-I9-STA-EXP-DT Numeric 8 (yyyymmdd)
Element: I9 Sta Exp Dt
APL-I9-ADMIT-NBR Alpha 13
Element: I9 Admit Nbr
APL-I9-AUTHORIZE Alpha 30 (Lower Case)
Element: I9 Authorize
APL-I9-DOC-TYPE Alpha 10 Occurs 2 Times
Element: I9 Doc Type
APL-I9-DOC-DESCR Alpha 10 Occurs 2 Times
Element: I9 Doc Descr
APL-I9-DOC-NBR Alpha 20 Occurs 2 Times
Element: I9 Doc Nbr
APL-I9-DOC-EXP-DT Numeric 8 (yyyymmdd) Occurs 2 Times
Element: I9 Doc Exp Dt
APL-SALARY-CLASS Alpha 1
Element: Salary Class H = Hourly
S = Salaried
APL-PAY-FREQUENCY Numeric 1
Element: Pay Frequency 1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = UK Four-Weekly
APL-EXEMPT-EMP Alpha 1
Element: Exempt Emp N = No
Y = Yes
APL-OT-PLAN-CODE Alpha 4
Element: Ot Plan Code Identifies pay plan in effect for
employee when PRDISTRIB record was
created from PR197 (PRPRD).
APL-SCHEDULE Alpha 9
Element: Schedule
APL-PAY-GRADE Alpha 3
Element: Pay Grade
APL-PAY-STEP Numeric 2
Element: Pay Step
APL-ANNUAL-HOURS Numeric 4
Element: Annual Hours
APL-LOCAT-CODE Alpha 10
Element: Locat Code
APL-HM-DIST-CO Numeric 4
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
APL-HM-ACCT-UNIT Alpha 15
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
APL-HM-ACCOUNT Numeric 6
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
APL-HM-SUB-ACCT Numeric 4
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
APL-ACTIVITY Alpha 15
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
APL-ACCT-CATEGORY Alpha 5
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
APL-SUPP-COUNTY Alpha 25 (Lower Case)
Element: County The county for the company address.
APPLICANT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APLSET1 COMPANY BN305 HAP3.1
APPLICANT HAPL.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR15.1
HR170 HR21.1
HR30.1 HR511
HR515 HR54.1
HR70.1 HR90.1
HREF.1 HRS1.1
HRSC.1 HS11.1
HS11.2 HS12.1
HS12.2 HS13.1
HS13.2 HS50.1
...
APLSET2 COMPANY KeyChange HAP2.1 PA231
LAST-NAME
FIRST-NAME
MIDDLE-INIT
APPLICANT
APLSET3 COMPANY KeyChange HAP3.1 PA31.1
FICA-NBR PA531
APPLICANT
APLSET4 COMPANY KeyChange, Subset PA534
EMPLOYEE Where EMPLOYEE != Zeroes
APPLICANT
APPLICANT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
App Status EMSTATUS Required
When APL-APP-STATUS != Spaces
APL-COMPANY -> EMS-COMPANY
APL-APP-STATUS -> EMS-EMP-STATUS
Base Currency CUCODES Required
When (APL-CURRENCY-CODE != Spaces )
APL-BASE-CURRENCY -> CUC-CURRENCY-CODE
Company PRSYSTEM Required
APL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
When (APL-COUNTRY-CODE != Spaces )
APL-COUNTRY-CODE -> INT-COUNTRY-CODE
Currency CUCODES Required
When (APL-CURRENCY-CODE != Spaces )
APL-CURRENCY-CODE -> CUC-CURRENCY-CODE
Currency2 CUCODES Required
When APL-CURR-CODE-2 != Spaces
APL-CURR-CODE-2 -> CUC-CURRENCY-CODE
Disability PCODES Required
When APL-DISABILITY != Spaces
"DI" -> PCO-TYPE
APL-DISABILITY -> PCO-CODE
Emp Status EMSTATUS Required
When APL-EMP-STATUS != Spaces
APL-COMPANY -> EMS-COMPANY
APL-EMP-STATUS -> EMS-EMP-STATUS
Employee EMPLOYEE Required
When APL-EMPLOYEE != Zeroes
APL-COMPANY -> EMP-COMPANY
APL-EMPLOYEE -> EMP-EMPLOYEE
Hire Source PCODES Required
When APL-HIRE-SOURCE != Spaces
"HS" -> PCO-TYPE
APL-HIRE-SOURCE -> PCO-CODE
Job1 JOBCODE Required
When APL-JOB1 != Spaces
APL-COMPANY -> JBC-COMPANY
APL-JOB1 -> JBC-JOB-CODE
Job2 JOBCODE Required
When APL-JOB2 != Spaces
APL-COMPANY -> JBC-COMPANY
APL-JOB2 -> JBC-JOB-CODE
Job3 JOBCODE Required
When APL-JOB3 != Spaces
APL-COMPANY -> JBC-COMPANY
APL-JOB3 -> JBC-JOB-CODE
Paempapp PAEMPAPP Required
APL-COMPANY -> PPP-COMPANY
APL-APPLICANT -> PPP-APPLICANT
Zeroes -> PPP-EMPLOYEE
Paemployee PAEMPLOYEE Required
When APL-EMPLOYEE != Zeroes
APL-COMPANY -> PEM-COMPANY
APL-EMPLOYEE -> PEM-EMPLOYEE
Prev Country INSTCTRYCD Required
When (APL-PREV-CNTRY-CD != Spaces )
APL-PREV-CNTRY-CD -> INT-COUNTRY-CODE
Process Level PRSYSTEM Required
When APL-PROCESS-LEVEL != Spaces
APL-COMPANY -> PRS-COMPANY
APL-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Rating PCODES Required
When APL-RATING != Spaces
"AR" -> PCO-TYPE
APL-RATING -> PCO-CODE
Religion PCODES Not Required
Valid When APL-RELIGION != Spaces
"RE" -> PCO-TYPE
APL-RELIGION -> PCO-CODE
Wk Rst Code1 PCODES Required
When APL-WK-RST-CODE1 != Spaces
"WR" -> PCO-TYPE
APL-WK-RST-CODE1 -> PCO-CODE
Wk Rst Code2 PCODES Required
When APL-WK-RST-CODE2 != Spaces
"WR" -> PCO-TYPE
APL-WK-RST-CODE2 -> PCO-CODE
Wk Rst Code3 PCODES Required
When APL-WK-RST-CODE3 != Spaces
"WR" -> PCO-TYPE
APL-WK-RST-CODE3 -> PCO-CODE
Wk Rst Code4 PCODES Required
When APL-WK-RST-CODE4 != Spaces
"WR" -> PCO-TYPE
APL-WK-RST-CODE4 -> PCO-CODE
APPLICANT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ce Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"CE" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Certificates EMPCODES Delete Cascades
APL-COMPANY -> EPC-COMPANY
"CE" -> EPC-TYPE
1 -> EPC-EMP-APP
APL-APPLICANT -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Competency EMPCODES Delete Cascades
APL-COMPANY -> EPC-COMPANY
1 -> EPC-EMP-APP
APL-APPLICANT -> EPC-EMPLOYEE
EPC-TYPE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Correspondence HRCORRESP
APL-COMPANY -> HCP-COMPANY
"2" -> HCP-REQ-TYPE
APL-APPLICANT -> HCP-ID-NBR
Zeroes -> HCP-DEPENDENT
HCP-SEQ-NBR
Ed Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"ED" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Education EMPCODES Delete Cascades
APL-COMPANY -> EPC-COMPANY
"ED" -> EPC-TYPE
1 -> EPC-EMP-APP
APL-APPLICANT -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Employers APPJOBHIST Delete Cascades
APL-COMPANY -> AJH-COMPANY
APL-APPLICANT -> AJH-APPLICANT
AJH-EMPLOYEE
AJH-EMPLOYER-NAME
AJH-SEQ-NBR
Ethnicity HRCTRYCODE
Valid When APL-EEO-CLASS != Spaces
"ET" -> CTC-TYPE
APL-EEO-CLASS -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
Ge Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"GE" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Hist Err HISTERR Delete Cascades
APL-COMPANY -> HER-COMPANY
APL-APPLICANT -> HER-EMPLOYEE
HER-OBJ-ID
HER-EFFECT-DATE
HER-ACTION-CODE
HER-ACTION-NBR
HER-FLD-NBR
HER-SEQ-NBR
Hrhistory HRHISTORY Delete Cascades
APL-COMPANY -> HRH-COMPANY
APL-APPLICANT -> HRH-EMPLOYEE
Zeroes -> HRH-OBJ-ID
99 -> HRH-POS-LEVEL
HRH-BEG-DATE
HRH-FLD-NBR
HRH-SEQ-NBR
Interview Date INTERVIEW Delete Cascades
APL-COMPANY -> ITV-COMPANY
1 -> ITV-EMP-APP
APL-APPLICANT -> ITV-APPLICANT
ITV-IV-DATE
ITV-SEQ-NBR
Interviews INTERVIEW Delete Cascades
APL-COMPANY -> ITV-COMPANY
1 -> ITV-EMP-APP
APL-APPLICANT -> ITV-APPLICANT
ITV-SEQ-NBR
Iv Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"IV" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Jh Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"JH" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
PAC-LN-NBR
PAC-SEQ-NBR
Job History APPJOBHIST Delete Cascades
APL-COMPANY -> AJH-COMPANY
APL-APPLICANT -> AJH-APPLICANT
Zeroes -> AJH-EMPLOYEE
AJH-SEQ-NBR
Job Interest PAJOBINTRS Delete Cascades
APL-COMPANY -> PJI-COMPANY
1 -> PJI-EMP-APP
APL-APPLICANT -> PJI-EMPLOYEE
PJI-JOB-CODE
PJI-POSITION
Jobauth JOBAUTH Delete Cascades
APL-COMPANY -> JBA-COMPANY
1 -> JBA-EMP-APP
APL-APPLICANT -> JBA-EMPLOYEE
JBA-JOB-CODE
JBA-POSITION
Md Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"MD" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Mi Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"MI" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Military MILITARY Delete Cascades
APL-COMPANY -> MIL-COMPANY
1 -> MIL-EMP-APP
APL-APPLICANT -> MIL-EMPLOYEE
MIL-BR-SERVICE
MIL-SEQ-NBR
Name Prefix HRCTRYCODE
Valid When APL-NAME-PREFIX != Spaces
"PR" -> CTC-TYPE
APL-NAME-PREFIX -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
Name Suffix HRCTRYCODE
Valid When APL-NAME-SUFFIX != Spaces
"SU" -> CTC-TYPE
APL-NAME-SUFFIX -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
Position1 PAPOSITION Required
When APL-POSITION1 != Spaces
APL-COMPANY -> POS-COMPANY
APL-POSITION1 -> POS-POSITION
POS-EFFECT-DATE
Position2 PAPOSITION Required
When APL-POSITION2 != Spaces
APL-COMPANY -> POS-COMPANY
APL-POSITION2 -> POS-POSITION
POS-EFFECT-DATE
Position3 PAPOSITION Required
When APL-POSITION3 != Spaces
APL-COMPANY -> POS-COMPANY
APL-POSITION3 -> POS-POSITION
POS-EFFECT-DATE
Ref Name REFERENC Delete Cascades
APL-COMPANY -> REF-COMPANY
APL-APPLICANT -> REF-APPLICANT
REF-LAST-NAME
REF-FIRST-NAME
REF-MIDDLE-INIT
REF-SEQ-NBR
References REFERENC Delete Cascades
APL-COMPANY -> REF-COMPANY
APL-APPLICANT -> REF-APPLICANT
REF-SEQ-NBR
Relocation EMPCODES Delete Cascades
APL-COMPANY -> EPC-COMPANY
"RL" -> EPC-TYPE
1 -> EPC-EMP-APP
APL-APPLICANT -> EPC-EMPLOYEE
EPC-CODE
EPC-SUBJECT
EPC-SEQ-NBR
Requis Log PAREQLOG Delete Cascades
APL-COMPANY -> PQL-COMPANY
1 -> PQL-EMP-APP
APL-APPLICANT -> PQL-APPLICANT
PQL-REQUISITION
PQL-DATE
PQL-SEQ-NBR
Requisitions PAREQAPP Delete Cascades
APL-COMPANY -> PRA-COMPANY
1 -> PRA-EMP-APP
APL-APPLICANT -> PRA-APPLICANT
PRA-REQUISITION
Rl Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"RL" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
Sk Comments PACOMMENTS Delete Cascades
APL-COMPANY -> PAC-COMPANY
1 -> PAC-EMP-APP
"SK" -> PAC-CMT-TYPE
APL-APPLICANT -> PAC-EMPLOYEE
Spaces -> PAC-JOB-CODE
Spaces -> PAC-ACTION-CODE
Zeroes -> PAC-LN-NBR
PAC-SEQ-NBR
User Fields HREMPUSF Delete Cascades
APL-COMPANY -> HEU-COMPANY
1 -> HEU-EMP-APP
APL-APPLICANT -> HEU-EMPLOYEE
HEU-FIELD-KEY
Veteran HRCTRYCODE
Valid When APL-VETERAN != Spaces
"VS" -> CTC-TYPE
APL-VETERAN -> CTC-HRCTRY-CODE
CTC-COUNTRY-CODE
Work Schedule HRWRKSCHD
Valid When APL-WORK-SCHED != Spaces
APL-COMPANY -> WSC-COMPANY
APL-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|
