Lookup Aliases
The following aliases have no special processing logic; they simply reference the value in the indicated field.
| Alias | Field | Table |
|---|---|---|
|
ACTION |
ACTION |
JOB |
|
ACTION_DT |
ACTION_DT |
JOB |
|
ACTION_RE |
ACTION_REASON |
JOB |
|
BIRTH_DT |
BIRTHDATE |
PERSON |
|
CHG_PCT |
CHANGE_PCT |
JOB |
|
DB_LIMIT |
DB_415E_LIMIT |
PA_DC_FRACT |
|
DC_FRACTN |
DC_FRACTION |
PA_DC_FRACT |
|
DEATH_DT |
DT_OF_DEATH |
PERSON |
|
DEPT_ID |
DEPTID |
JOB |
|
EMPL_CLASS |
EMPL_CLASS |
JOB |
|
EMPL_ID |
EMPLID |
JOB |
|
EMPL_NAME |
NAME |
PERSON_NAME |
|
EMPL_STAT |
EMPL_STATUS |
JOB |
|
EMPL_TYPE |
EMPL_TYPE |
JOB |
|
FORP_TIME |
FULL_PART_TIME |
JOB |
|
HIRE_DT |
HIRE_DT |
EMPLOYMENT |
|
JOBCODE |
JOBCODE |
JOB |
|
MARSTAT |
EFFDT |
PERSONAL_DT_FST |
|
MARSTAT_DT |
MAR_STATUS_DT |
PERSONAL_DT_FST |
|
OFFICER_CD |
OFFICER_CD |
JOB |
|
OHIRE_DT |
ORIG_HIRE_DT |
PERSONAL_DT_FST |
|
REG_TEMP |
REG_TEMP |
JOB |
|
SBIRTH_DT |
BIRTHDATE |
DEPENDENT_BENEF |
|
QDRO_FLAG |
QDRO_IND_YN |
PA_QDRODAT |
|
SEX |
SEX |
PERSONAL_DT_FST |
|
STD_HOURS |
STD_HOURS |
JOB |
|
UNION_CD |
UNION_CD |
JOB_LABOR |