| Data element |
Definition |
EMPLID
Indexed - Yes
Format - VARCHAR2
Nullable - N | Unique identifier for individual (non-org) records. |
"
START_DT
Indexed - Yes
Format - DATE
Nullable - N | Start date of employment. |
"
SEQUENCE_NBR
Indexed - Yes
Format - NUMBER
Nullable - N | One-up number. |
"
EMPLOYER
Indexed - No
Format - VARCHAR2
Nullable - N | Name of employer. |
"
CITY
Indexed - No
Format - VARCHAR2
Nullable - N | City description |
"
STATE
Indexed - No
Format - VARCHAR2
Nullable - N | Two digit state code (ex. PA) |
"
COUNTRY
Indexed - No
Format - VARCHAR2
Nullable - N | Three digit country abbreviation (ex. 'USA') |
"
COUNTRY_CODE
Indexed - No
Format - VARCHAR2
Nullable - N | |
"
PHONE
Indexed - No
Format - VARCHAR2
Nullable - N | |
"
END_DT
Indexed - No
Format - DATE
Nullable - Y | |
"
ENDING_TITLE
Indexed - No
Format - VARCHAR2
Nullable - N | Job Title |
"
ENDING_RATE
Indexed - No
Format - NUMBER
Nullable - N | Not used. |
"
PAY_FREQ_ABBRV
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
CURRENCY_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Country code for currency (most often USD) |
"
US_SOC_CD
Indexed - Yes
Format - VARCHAR2
Nullable - N | Occupation code. |
"
CAN_NOC_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
REL_WRK_EXPER
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GRADE
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
FULL_PART_TIME
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
REG_TEMP
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_PAY_PLAN
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_OCC_SERIES
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_TYPE_OF_APPT
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_HOURS_PER_WEEK
Indexed - No
Format - NUMBER
Nullable - N | Not used. |
"
GVT_POSN_OCCUPIED
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_TENURE
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
GVT_TYPE_OF_EXP
Indexed - No
Format - VARCHAR2
Nullable - N | Not used. |
"
EXT_ORG_ID
Indexed - Yes
Format - VARCHAR2
Nullable - N | unique identifier for org (non-individual) records |
"
US_SIC_CD
Indexed - No
Format - VARCHAR2
Nullable - N | Industry code. |
"
RETIREMENT_DT
Indexed - No
Format - DATE
Nullable - Y | Date of retirement. |
"
UP_RETIREMENT_FLAG
Indexed - No
Format - VARCHAR2
Nullable - N | Indicator that the individual has retired from this job. |
"
PRIMARY_FLAG
Indexed - No
Format - VARCHAR2
Nullable - N | Indicates that this row is the primary employment record. |
"
DATETIME_UPDATED
Indexed - No
Format - DATE
Nullable - Y | Date and time of data update. |
"
UP_ENDING_TITLE
Indexed - No
Format - VARCHAR2
Nullable - N | Job title. |
"
UP_EMPLOYER
Indexed - No
Format - VARCHAR2
Nullable - N | Employer Name. |
"
UP_DEPARTMENT
Indexed - No
Format - VARCHAR2
Nullable - N | Division within employer. |
"
DESCRLONG
Indexed - No
Format - LONG
Nullable - Y | Not used. |
"
