|
APPLICANT FILE
Applicant
The Applicant file contains information on applicants.
REFERENCED BY
HAP3.1 HAPL.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR00.1 HR01.1 HR15.1 HR170 HR30.1 HR515
HR54.1 HR70.1 HREF.1 HRS1.1 HRSC.1 HS50.1
HS50.2 HS50.5 HS51.1 HS51.2 HS52.1 HS52.2
PA102 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 PA53.1 PA533 PA535 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 PBIP.1 PR197 PRSC.1 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 fax number
extension.
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 1 PA31.1 PA531
Element: Veteran Indicates whether the applicant is a
veteran.
1 = Veteran
2 = Disabled Veteran
3 = Vietnam Era Veteran
4 = Vietnam Era Disabled Veteran
5 = Gulf War Era Veteran
6 = Special Disabled Veteran
7 = Other Eligible Veteran
8 = Newly Separated Veteran
N = No
Y = Yes
X = Not Disclosed
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 Contains the user ID of the person who
last changed this record.
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
Account Currency Represents the number of decimals
Code defined for the currency of the object.
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: Date of Birth Contains the applicant's birthdate.
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
Base Number Of The number of decimal positions defined
Decimals 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
Report Currency 2 Contains the currency in which the
Code finder's fee is recorded.
APL-CURR-CODE-ND-2 Numeric 1 PA31.1 PA531
Account Currency The number of decimal positions defined
Code for Report Currency 2.
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 Address 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
APPLICANT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
APLSET1 COMPANY HAP3.1 HAPL.1
APPLICANT HEP4.1 HPOS.1
HPQC.1 HPRS.1
HR00.1 HR01.1
HR15.1 HR170
HR30.1 HR515
HR54.1 HR70.1
HR90.1 HREF.1
HRS1.1 HRSC.1
HS50.1 HS50.2
HS50.5 HS51.1
HS51.2 HS52.1
HS52.2 PA100
PA102 PA120
PA135 PA149
...
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
Work Schedule HRWRKSCHD
Valid When APL-WORK-SCHED != Spaces
APL-COMPANY -> WSC-COMPANY
APL-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|