APPLICANT

Applicant

The Applicant file contains information on applicants.

REFERENCED BY
BN305 HCRE.1 HEP4.1 HLTM.1 HPOS.1 HPQC.1
HPRS.1 HR11.1 HR11.2 HR15.1 HR30.1 HR51.2
HR51.8 HR511 HR54.1 HR93.3 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 PA149 PA19.1 PA232 PA233 PA234
PA235 PA236 PA238 PA241 PA242 PA243
PA244 PA248 PA249 PA258 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 PA58.1 PA62.1
PA63.1 PA64.1 PA64.2 TR120 TR121 TR20.1
TR20.2 TR20.3 TR20.4 TR22.1 TR500 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9


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 HAP3.1 HAPL.1
HR00.1 HR01.1 HR170 HR515 HR70.1 PA135
PA231 PA239 PA240 PA65.1 PA65.2 HAP2.1
PA534

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
APL-COMPANY
Element: Company		Numeric 4
Contains the company number which represents an established company.
PA31.1 PA39.1
PA40.1 PA531
APL-APPLICANT
Element: Applicant		Numeric 9
Contains the applicant's number. The number correlates all information about the applicant.
PA31.1 PA39.1
PA40.1 PA531
APL-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
Contains the applicant's last name.
PA31.1 PA43.1
PA531
APL-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
Contains the applicant's first name.
PA31.1 PA43.1
PA531
APL-MIDDLE-NAME
Element: Middle Name		Alpha 15 (Lower Case)
Contains the applicant's middle name.
PA31.1 PA531
APL-MIDDLE-INIT
Element: Middle Initial		Alpha 1
Contains the applicant's middle initial.
PA31.1 PA43.1
PA531
APL-NICK-NAME
Element: Nick Name		Alpha 30 (Lower Case)
Contains the applicant's nickname.
PA31.1 PA531
APL-ADDR1
Element: Address 1		Alpha 30 (Lower Case)
Contains the first line of the applicant's address.
PA31.1 PA531
APL-ADDR2
Element: Address 2		Alpha 30 (Lower Case)
Contains the second line of the applicant's address.
PA31.1 PA531
APL-ADDR3
Element: Address 3		Alpha 30 (Lower Case)
Contains the third line of the applicant's address.
PA31.1 PA531
APL-ADDR4
Element: Address 4		Alpha 30 (Lower Case)
Contains the fourth line of the applicant's address.
PA31.1 PA531
APL-CITY
Element: City		Alpha 18 (Lower Case)
Contains the city of the applicant's address.
PA31.1 PA531
APL-STATE
Element: State or Province		Alpha 2
Contains the state of the applicant's address.
PA31.1 PA531
APL-ZIP
Element: Postal Code		Alpha 10
Contains the postal code of the applicant's address.
PA31.1 PA531
APL-HM-PHONE-CNTRY
Home Phone Country
Code		Alpha 6
Contains the prefix of the applicant's home telephone.
PA31.1 PA531
APL-HM-PHONE-NBR
Element: Home Phone Number		Alpha 15
Contains the applicant's home telephone number.
PA31.1 PA531
APL-WK-PHONE-CNTRY
Work Phone Country
Code		Alpha 6
Contains the prefix of the applicant's work telephone number.
PA31.1 PA531
APL-WK-PHONE-NBR
Element: Work Phone Number		Alpha 15
Contains the applicant's work telephone number.
PA31.1 PA531
APL-WK-PHONE-EXT
Element: Work Phone Extension		Alpha 5
Contains the extension of the applicant's work telephone number.
PA31.1 PA531
APL-FAX-COUNTRY
Element: Fax Country Code		Alpha 6
Contains the prefix of the fax number. For example, the country or city code.
PA31.1 PA531
APL-FAX-NBR
Element: Fax Number		Alpha 15
Contains the applicant's fax telephone number.
PA31.1 PA531
APL-FAX-EXT
Element: Fax Extension Number		Alpha 5
This field contains the telephone extension number.
PA31.1 PA531
APL-DATE-HIRED
Element: Hire Date		Numeric 8 (yyyymmdd)
Contains the date the applicant was hired.
PA100 PA31.1
PA52.4 PA531
APL-APP-STATUS
Element: Applicant Status		Alpha 2
Contains the applicant's status.
PA31.1 PA531
APL-FICA-NBR
Element: Social Number		Alpha 20
Contains the applicant's Social Security number.
PA31.1 PA531
APL-DATE-APPLIED
Element: Date Applied		Numeric 8 (yyyymmdd)
Contains the date the applicant applied.
PA31.1 PA531
APL-HIRE-SOURCE
Element: Hire Source		Alpha 10
Indicates how the applicant found out about job. This must be valid in the Human Resource Codes file.
PA31.1 PA531
APL-REF-LST-NAME
Referred By Last
Name		Alpha 30 (Lower Case)
Contains the last name of the employee who referred the applicant.
PA31.1 PA531
APL-REF-FST-NAME
Referred By First
Name		Alpha 15 (Lower Case)
Contains the first name of the employee who referred the applicant.
PA31.1 PA531
APL-REF-MID-INIT
Referred By Middle
Initial		Alpha 1
Contains the middle initial of the employee who referred the applicant.
PA31.1 PA531
APL-FINDERS-FEE
Element: Finders Fee		Numeric 10
Contains the finders fee.
PA31.1 PA531
APL-PREV-APPLY
Element: Previously Applied		Alpha 1
Indicates whether the applicant previously applied with company.
N = No
Y = Yes
PA31.1 PA531
APL-PREV-LOCATION
Element: Where		Alpha 30 (Lower Case)
Contains the location to which the applicant previously applied.
PA31.1 PA531
APL-PREV-DATE
Element: When		Numeric 8 (yyyymmdd)
Contains the date the applicant previously applied.
PA31.1 PA531
APL-PREV-EMPLOY
Element: Previously Employed		Alpha 1
Indicates whether the applicant previously worked for the company.
N = No
Y = Yes
PA31.1 PA531
APL-PREV-EMP-NBR
Element: Employee Number		Numeric 9
Contains the applicant's previous employee number.
PA31.1 PA531
APL-PREV-LOC-WORK
Element: Where		Alpha 30 (Lower Case)
Contains the applicant's previous work location.
PA31.1 PA531
APL-PREV-BEG-DATE
Element: When - Begin Date		Numeric 8 (yyyymmdd)
Contains the beginning date of the applicant's previous employment.
PA31.1 PA531
APL-PREV-END-DATE
Element: When - End Date		Numeric 8 (yyyymmdd)
Contains the ending date of the applicant's previous employment.
PA31.1 PA531
APL-RATING
Element: Rating		Alpha 10
Contains applicant rating codes.
PA31.1 PA531
APL-FORMER-LST-NM
Element: Former Last Name		Alpha 30 (Lower Case)
Contains the former last name of the applicant.
PA31.1 PA531
APL-FORMER-FST-NM
Element: Former First Name		Alpha 15 (Lower Case)
Contains the former first name of the applicant.
PA31.1 PA531
APL-FORMER-MI
Former Middle
Initial		Alpha 1
Contains the former middle initial of the applicant.
PA31.1 PA531
APL-PREV-ADDR1
Element: Previous Address 1		Alpha 30 (Lower Case)
Contains the first line of the applicant's previous address.
PA31.1 PA531
APL-PREV-ADDR2
Element: Previous Address 2		Alpha 30 (Lower Case)
Contains the second line of the applicant's previous address.
PA31.1 PA531
APL-PREV-ADDR3
Element: Previous Address 3		Alpha 30 (Lower Case)
Contains the third line of the applicant's previous address.
PA31.1 PA531
APL-PREV-ADDR4
Element: Previous Address 4		Alpha 30 (Lower Case)
Contains the fourth line of the applicant's previous address.
PA31.1 PA531
APL-PREV-CITY
Element: City		Alpha 18 (Lower Case)
Contains the city of the applicant's previous address.
PA31.1 PA531
APL-PREV-STATE
Element: State or Province		Alpha 2
Contains the state of the applicant's previous address.
PA31.1 PA531
APL-PREV-ZIP
Element: Postal Code		Alpha 10
Contains the postal code of the applicant's previous address.
PA31.1 PA531
APL-PREV-CNTRY-CD
Element: Prev Cntry Cd		Alpha 2
Contains the country code for the applicant's previous address.
PA31.1 PA531
APL-EEO-CLASS
Element: EEO Class		Alpha 4 (Lower Case)
Contains the applicant's EEO-class.
PA31.1 PA531
APL-SEX
Element: Gender		Alpha 1
Contains the applicant's sex.
F = Female
M = Male
X = Not Disclosed
PA31.1 PA531
APL-AGE-FLAG
Element: Age		Alpha 1
Indicates whether the applicant is between the ages of 18 and 70.
Y = Yes
N = No
PA31.1 PA531
APL-HANDICAP-ID
Element: Disability		Alpha 1
Indicates whether the applicant is disabled.
Y = Yes
N = No
X = Not Disclosed
PA31.1 PA531
APL-JOB1
Element: Primary Job Code		Alpha 9
Contains the job code of the applicant's first job choice.
PA31.1 PA531
APL-JOB2
Element: Secondary Job Code		Alpha 9
Contains the job code of the applicant's second job choice.
PA31.1 PA531
APL-JOB3
Element: Tertiary Job Code		Alpha 9
Contains the job code of the applicant's third job choice.
PA31.1 PA531
APL-BEG-PAY
Element: Beginning Pay		Signed 11.2
Contains the minimum expected pay.
PA31.1 PA531
APL-END-PAY
Element: Ending Pay		Signed 11.2
Contains the maximum expected pay.
PA31.1 PA531
APL-DATE-AVAIL
Element: Date Available		Numeric 8 (yyyymmdd)
Contains the date the applicant is available to begin work.
PA31.1 PA531
APL-VETERAN
Element: Veteran		Alpha 4
Indicates whether the applicant is a veteran.
PA31.1 PA531
APL-DRAFT-STATUS
Bill of Exchange
Status		Alpha 3
Contains the user-defined draft status.
PA31.1 PA39.1
PA531
APL-FINAL-RANK
Element: Final Military Rank		Alpha 3
Contains the applicant's final military rank.
PA31.1 PA39.1
PA531
APL-CUR-STATUS
Element: Current Status		Alpha 2
Indicates the applicant's current military status.
NG = National Guard
RE = Reserves
PA31.1 PA39.1
PA531
APL-LAST-PHYSICAL
Element: Last Physical Date		Numeric 8 (yyyymmdd)
Contains the date of the last physical examination.
PA31.1 PA40.1
PA531
APL-WK-RST-CODE1
Work Restriction
Code 1		Alpha 10
Contains the first work restriction code for the applicant.
PA31.1 PA40.1
PA531
APL-WK-RST-CODE2
Work Restriction
Code 2		Alpha 10
Contains the second work restriction code for the applicant.
PA31.1 PA40.1
PA531
APL-WK-RST-CODE3
Work Restriction
Code 3		Alpha 10
Contains the third work restriction code for the applicant.
PA31.1 PA40.1
PA531
APL-WK-RST-CODE4
Work Restriction
Code 4		Alpha 10
Contains the fourth work restriction code for the applicant.
PA31.1 PA40.1
PA531
APL-RESUME
Element: Resume Received		Alpha 1
Indicates whether the applicant's resume has been received.
Y = Yes
N = No
PA31.1 PA531
APL-LAST-COM-SEQ
Last Comment
Sequence Number		Numeric 4
Contains the last sequence number used for the Personnel Comments file.
HR90.1 PA31.1
PA531
APL-LAST-REF-SEQ
Last Reference
Sequence Nmbr		Numeric 4
Contains the last sequence number used for references.
PA31.1 PA32.1
PA531
APL-LAST-INT-SEQ
Last Interview
Sequence Number		Numeric 4
Contains the last sequence number used for interviews.
PA31.1 PA41.1
PA531
APL-LAST-MIL-SEQ
Last Military
Sequence Number		Numeric 4
Contains the last sequence number used for military service record.
PA31.1 PA39.1
PA531
APL-LAST-EPC-SEQ
Last Emp Code
Sequence Number		Numeric 4
Contains the last sequence number used for employee codes.
PA20.1 PA21.1
PA22.1 PA24.1
PA27.1 PA31.1
PA34.1 PA35.1
PA36.1 PA38.1
PA520 PA531
TR21.1 TR26.1
APL-POSITION1
Primary Position
Number		Alpha 12
Contains the first position in which the applicant is interested.
PA31.1 PA531
APL-POSITION2
Secondary Position
Number		Alpha 12
Contains the second position in which the applicant is interested.
PA31.1 PA531
APL-POSITION3
Tertiary Position
Number		Alpha 12
Contains the third position in which the applicant is interested.
PA31.1 PA531
APL-PROCESS-LEVEL
Element: Process Level		Alpha 5
Contains the process level the applicant is associated with.
PA31.1 PA531
APL-EMP-STATUS
Element: Employee Status		Alpha 2
Contains the employee status that indicates whether the applicant wants to work full-time, part-time, seasonal, temporary, and so on.
PA31.1 PA531
APL-WORK-SCHED
Element: Work Schedule		Alpha 10
Contains the work schedule that indicates when the applicant wants to work.
PA31.1 PA531
APL-SEC-LVL
Element: Security Level		Numeric 1
This field is not used. It is for future security enhancements.
PA31.1 PA531
APL-SEC-LOCATION
Element: Security Location		Alpha 10
This field is not used. It is for future security enhancements.
PA31.1 PA531
APL-NBR-FTE
Full Time
Equivalent Number		Signed 7.6
Contains the FTE (Full-Time 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.
PA31.1 PA531
APL-PIN
Element: Pin		Alpha 10 (Lower Case)
Contains the applicant personal ID number. This is used for Employee Self-Service.
PA31.1 PA531
APL-ELIG-WORK
Element: Elig Work		Alpha 1
Indicates whether the applicant is eligible to work in the United States.
Y = Yes
N = No
PA31.1 PA531
APL-TRAV-AVAIL
Element: Trav Avail		Alpha 1
Indicates whether the applicant is available for travel.
Y = Yes
N = No
PA31.1 PA531
APL-TRAV-PCT
Element: Trav Pct		Numeric 3
Indicates the percentage the applicant is available for travel.
PA31.1 PA531
APL-RELOC-AVAIL
Element: Reloc Avail		Alpha 1
Indicates whether the applicant is available for relocation.
Y = Yes
N = No
PA31.1 PA531
APL-OT-AVAIL
Element: Ot Avail		Alpha 1
Indicates whether the applicant is available for overtime.
Y = Yes
N = No
PA31.1 PA531
APL-EMAIL-ADDRESS
Element: Email Address		Alpha 60 (Lower Case)
Contains the applicant's email address.
PA31.1 PA531
APL-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.
PA31.1 PA531
APL-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
PA31.1 PA531
APL-USER-ID
Element: User		Alpha 10 (Lower Case)
PA31.1 PA531
APL-EMPLOYEE
Element: Employee		Numeric 9
Contains the name of the employee to contact when the applicant is hired.
PA100 PA31.1
PA52.4 PA531
APL-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the pay is recorded.
PA31.1 PA531
APL-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA31.1 PA531
APL-COUNTRY-CODE
Element: Country Code		Alpha 2
Contains the country of the applicant's address.
PA31.1 PA531
APL-BIRTHDATE
Element: Birthdate		Numeric 8 (yyyymmdd)
Contains the applicant's birth date.
PA31.1 PA531
APL-LANGUAGE-CODE
Element: Language Code		Alpha 10
Contains the applicant's language, if other than the company's default language.
PA31.1 PA531
APL-NAME-PREFIX
Element: Name Prefix		Alpha 4 (Lower Case)
Contains the applicant's title.
PA31.1 PA531
APL-NAME-SUFFIX
Element: Name Suffix		Alpha 4 (Lower Case)
Contains the applicant's name suffix.
PA31.1 PA531
APL-DISABILITY
Element: Disability		Alpha 10
Indicates the type of disability the applicant has.
PA31.1 PA531
APL-BASE-BEG-PAY
Element: Salary		Signed 11.2
Contains the applicant's beginning pay (of the previous job) in the company's base currency.
PA31.1 PA531
APL-BASE-END-PAY
Element: Salary		Signed 11.2
Contains the applicant's ending pay (of previous job) in the company's base currency.
PA31.1 PA531
APL-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company base currency.
PA31.1 PA531
APL-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
PA31.1 PA531
APL-BASE-FEE
Element: Base Fee		Numeric 10
Contains the finder's fee in the company's base currency.
PA31.1 PA531
APL-CURR-CODE-2
Element: Curr Code 2		Alpha 5
Contains the currency in which the finder's fee is recorded.
PA31.1 PA531
APL-CURR-CODE-ND-2
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA31.1 PA531
APL-RELIGION
Element: Religion		Alpha 10
Contains the applicant's religion.
PA31.1 PA531
APL-LAST-NAME-PRE
Element: Last Name Pre		Alpha 30 (Lower Case)
PA31.1 PA531
APL-CONSENT
Element: Consent		Alpha 1

N = No
Y = Yes
" " = No
PA31.1 PA531
APL-LAST-PRE
Element: Last Pre		Derived
APL-LAST-SUF
Element: Last Suf		Derived
APL-LAST-PRE-SUF
Element: Last Pre Suf		Derived
APL-LAST-NAME-EXP
Element: Last Name Exp		Derived
APL-FIRST-MI
Element: First Mi		Derived
APL-FIRST-MI-EXP
Element: First Mi Exp		Derived
APL-LABEL-NAME
Element: Label Name		Derived
Contains the applicant's name, as it should appear on labels.
APL-LABEL-ADDR
Element: Label Addr		Derived
Contains the applicants address as it should appear on labels.
APL-FULL-NAME
Element: Full Name		Derived
Contains the applicant's full name.
APL-SHORT-NAME
Element: Short Name		Derived
Contains the applicant's short name.
APL-COUNTY
Element: County		Alpha 25 (Lower Case)
The county for the company address.
PA31.1 PA531
APL-LABEL-NAME-1
Element: Label Name 1		Derived
APL-SUPP-ADDR1
Element: Supp Addr1		Alpha 30 (Lower Case)
APL-SUPP-ADDR2
Element: Supp Addr2		Alpha 30 (Lower Case)
APL-SUPP-ADDR3
Element: Supp Addr3		Alpha 30 (Lower Case)
APL-SUPP-ADDR4
Element: Supp Addr4		Alpha 30 (Lower Case)
APL-SUPP-CITY
Element: Supp City		Alpha 18 (Lower Case)
APL-SUPP-STATE
Element: Supp State		Alpha 2
APL-SUPP-ZIP
Element: Supp Zip		Alpha 10
APL-SUPP-CNTRY-CD
Element: Supp Cntry Cd		Alpha 2
APL-SUPP-PHONE-CNT
Element: Supp Phone Cnt		Alpha 6
APL-SUPP-PHONE-NBR
Element: Supp Phone Nbr		Alpha 15
APL-REQ-FILLED
Element: Req Filled		Numeric 9
APL-POS-FILLED
Element: Pos Filled		Alpha 12
APL-JOB-FILLED
Element: Job Filled		Alpha 9
APL-HIRED-PAY-RATE
Element: Hired Pay Rate		Signed 13.4
APL-SUPERVISOR
Element: Supervisor		Alpha 10
APL-NBR-FTE-HIRED
Element: Nbr Fte Hired		Signed 7.6
APL-BIRTH-CITY
Element: Birth City		Alpha 18 (Lower Case)
APL-BIRTH-STATE
Element: Birth State		Alpha 2
APL-BIRTH-CNTRY-CD
Element: Birth Cntry Cd		Alpha 2
APL-VISIBLE-MIN
Element: Visible Min		Alpha 1

N = No
Y = Yes
APL-ABORIGINAL
Element: Aboriginal		Alpha 1

N = No
Y = Yes
APL-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
PA31.1 PA531
APL-UNION-CODE
Element: Union Code		Alpha 10
APL-BARGAIN-UNIT
Element: Bargain Unit		Alpha 10
APL-SUPERVISOR-IND
Element: Supervisor		Alpha 10
APL-I9-STATUS
Element: I9 Status		Alpha 10
APL-I9-ALIEN-NBR
Element: I9 Alien Nbr		Alpha 11
APL-I9-STA-EXP-DT
Element: I9 Sta Exp Dt		Numeric 8 (yyyymmdd)
APL-I9-ADMIT-NBR
Element: I9 Admit Nbr		Alpha 13
APL-I9-AUTHORIZE
Element: I9 Authorize		Alpha 30 (Lower Case)
APL-I9-DOC-TYPE
Element: I9 Doc Type		Alpha 10 Occurs 2 Times
APL-I9-DOC-DESCR
Element: I9 Doc Descr		Alpha 10 Occurs 2 Times
APL-I9-DOC-NBR
Element: I9 Doc Nbr		Alpha 20 Occurs 2 Times
APL-I9-DOC-EXP-DT
Element: I9 Doc Exp Dt		Numeric 8 (yyyymmdd) Occurs 2 Times
APL-SALARY-CLASS
Element: Salary Class		Alpha 1

H = Hourly
S = Salaried
APL-PAY-FREQUENCY
Element: Pay Frequency		Numeric 1

1 = Weekly
2 = Biweekly
3 = Semimonthly
4 = Monthly
5 = UK Four-Weekly
APL-EXEMPT-EMP
Element: Exempt Emp		Alpha 1

N = No
Y = Yes
APL-OT-PLAN-CODE
Element: Ot Plan Code		Alpha 4
Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).
APL-SCHEDULE
Element: Schedule		Alpha 9
APL-PAY-GRADE
Element: Pay Grade		Alpha 3
APL-PAY-STEP
Element: Pay Step		Numeric 2
APL-ANNUAL-HOURS
Element: Annual Hours		Numeric 4
APL-LOCAT-CODE
Element: Locat Code		Alpha 10
APL-HM-DIST-CO
Element: Company		Numeric 4
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
Element: Acct Unit		Alpha 15
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
Element: Account		Numeric 6
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
Element: Sub Acct		Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
APL-ACTIVITY
Element: Activity		Alpha 15
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
Element: Acct Category		Alpha 5
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
Element: County		Alpha 25 (Lower Case)
The county for the company address.
APL-L-HIRE-DATE
Element: Date		Numeric 8 (yyyymmdd)
PA31.1 PA531
APL-L-ADJ-HIRE-DT
Element: Date		Numeric 8 (yyyymmdd)
PA31.1 PA531
APL-L-ANNIVR-DATE
Element: Date		Numeric 8 (yyyymmdd)
PA31.1 PA531
APL-L-SENIOR-DATE
Element: Date		Numeric 8 (yyyymmdd)
PA31.1 PA531
APL-L-TRUE-MAR-ST
Element: Flag		Alpha 1
PA31.1 PA531
APL-L-FIRST-DAY-WK
Element: Date		Numeric 8 (yyyymmdd)
PA31.1 PA531
APL-L-WRK-SCH-HIRE
Element: Alpha 10		Alpha 10
PA31.1 PA531
APL-L-SHIFT-HIRED
Element: Flag Num		Numeric 1
PA31.1 PA531
APL-L-ORG-UNIT
Element: Org Unit		Numeric 6
PA31.1 PA531
APL-L-CANDIDATE-ID
Element: Candidate Id		Numeric 10
PA31.1 PA531
APL-L-JOB-APP
Element: Jobapplication		Numeric 4
PA31.1 PA531
APL-L-JOB-REQ
Element: Jobrequisition		Numeric 9
PA31.1 PA531


APPLICANT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APLSET1 COMPANY
APPLICANT
...
BN305 HAP3.1
HAPL.1 HCRE.1
HEP4.1 HLTM.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
HR01.1 HR11.1
HR11.2 HR15.1
HR170 HR30.1
HR51.2 HR51.8
HR511 HR515
HR54.1 HR70.1
HR90.1 HR93.3
HREF.1 HRS1.1
HRSC.1 HS11.1
HS11.2 HS12.1
APLSET2 COMPANY
LAST-NAME
FIRST-NAME
MIDDLE-INIT
APPLICANT
KeyChange
HAP2.1 PA231
APLSET3 COMPANY
FICA-NBR
APPLICANT
KeyChange
HAP3.1 PA31.1
PA531
APLSET4 COMPANY
EMPLOYEE
APPLICANT
KeyChange, Subset
WhereEMPLOYEE !=Zeroes
PA534


APPLICANT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
  WSC-CONTRACT-YEAR

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

Home
Contact Us



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