EMPL_LAB_INFO

AA_COMMENTS

Comments

N

N/A

EMPL_LAB_INFO

AFF_PLAN_CD

AA plan code

Y (

if:

• Licensed for HR
• Employee is Part-Time or Regular
• A labor location is assigned to the employee
• Employee's labor location is assigned to an Affirmative Action Plan that is assigned to the employee's Taxable Entity and with a coverage start date that is before or on the effective date in EMPL_LAB_INFO table.

)

CP Job Template, Taxable Entity/Labor Location Default

EMPL_LAB_INFO

ANNL_AMT

Annual amount

Y (either the hourly, the salary, or the annual amount must be entered. Type of amount sent is based on the job classification in Deltek Talent Management)

offer_salary or position_salary

EMPL_LAB_INFO

BILL_LAB_CAT_CD

Project labor category (PLC)

N

CP Job Template

EMPL_LAB_INFO

COMMENTS

Comments

N

N/A

EMPL_LAB_INFO

COMP_PLAN_CD

Compensation plan code

Y (if licensed for HR and at least one Compensation Plan Code record exists in the COMP_PLAN_SETUP table)

Manage Compensation Plan Defaults, Manage Detail Position Descriptions, Configure Compensation Settings

EMPL_LAB_INFO

CORP_OFCR_FL

Corporate officer flag (Y/N)

N

CP Job Template, Detail Job Title

EMPL_LAB_INFO

DETL_JOB_CD

Detail job code

Y (Required if at least one Detail Job Code record exists in the DETL_JOB_TITLE table)

job_code or CP Job Template

EMPL_LAB_INFO

DFLT_RT_GRP_ID

Default rate group

Y (if the employee's currency code is different from the system's functional currency)

CP Job Template

EMPL_LAB_INFO

EFFECT_DT

Effective date

Y

candidate_start_date

EMPL_LAB_INFO

EMPL_CLASS_CD

Employee class code

N

CP Job Template

EMPL_LAB_INFO

EMPL_ID

Employee ID

Y (if auto ID generation is not enabled)

user_employee_id

EMPL_LAB_INFO

END_DT

End date

N

“12/31/2078”

EMPL_LAB_INFO

EXMPT_FL

Exempt flag (Y/N)

N

req_exemption or CP Job Template

EMPL_LAB_INFO

GENL_LAB_CAT_CD

General labor Category (GLC)

Y

CP Job Template, First Valid

EMPL_LAB_INFO

HIRE_DT_FL

Effective hire date flag (Y/N)

N

"Y"

EMPL_LAB_INFO

HOME_REF1_ID

Home reference 1

N

CP Job Template

EMPL_LAB_INFO

HOME_REF2_ID

Home reference 2

N

CP Job Template

EMPL_LAB_INFO

HR_ORG_ID

HR organization ID

N

CP Job Template

EMPL_LAB_INFO

HRLY_AMT

Hourly rate

Y (either the hourly, the salary, or the annual amount must be entered. Type of amount sent is based on the job classification in Deltek Talent Management)

offer_salary or position_salary

EMPL_LAB_INFO

JOB_GROUP_CD

Job group

Y (if there is a job group code assigned to the functional job title which is linked to the employee's detail job title)

CP Job Template

EMPL_LAB_INFO

LAB_GRP_TYPE

Labor group type

N

CP Job Template

EMPL_LAB_INFO

LAB_LOC_CD

Labor location

Y (if an affirmative action Plan is specified)

CP Job Template

EMPL_LAB_INFO

MERIT_PCT_RT

Merit percent

N

N/A

EMPL_LAB_INFO

MGR_EMPL_ID

Evaluating manager's employee ID

N

manager_id or CP Job Template

EMPL_LAB_INFO

MODIFIED_BY

ID of user who last created or modified row

N

N/A

EMPL_LAB_INFO

ORG_ID

Org ID

Y

req_department_code

EMPL_LAB_INFO

OVERALL_RT

Performance rating

N

N/A

EMPL_LAB_INFO

PCT_INCR_RT

Percent increase

N

N/A

EMPL_LAB_INFO

PERS_ACT_RSN_CD

Personnel action reason

N

CP Job Template

EMPL_LAB_INFO

PERS_ACT_RSN_CD_2

Personnel action reason 2

N

N/A

EMPL_LAB_INFO

PERS_ACT_RSN_CD_3

Personnel action reason 3

N

N/A

EMPL_LAB_INFO

PROMO_PCT_RT

Promotion percent

N

N/A

EMPL_LAB_INFO

REASON_DESC

Reason description

N

CP Job Template or Personnel Action table

EMPL_LAB_INFO

REASON_DESC_2

Reason description 2

N

N/A

EMPL_LAB_INFO

REASON_DESC_3

Reason description 3

N

N/A

EMPL_LAB_INFO

REVIEW_FORM_ID

Review form ID

N

CP Job Template

EMPL_LAB_INFO

ROWVERSION

System-assigned number to handle row concurrency

N

N/A

EMPL_LAB_INFO

S_EMPL_TYPE_CD

Employee type code

Y

requisition_job_type or CP Job Template

EMPL_LAB_INFO

S_HRLY_SAL_CD

Hourly or salary code

Y

requisition_position_type or CP Job Template

EMPL_LAB_INFO

S_STEP_NO

Step number values 1-10

Y (if licensed for HR and the compensation plan type is Step.

CP Job Template

EMPL_LAB_INFO

SAL_AMT

Salary amount

Y (either the hourly, the salary, or the annual amount must be entered)

offer_salary or position_salary

EMPL_LAB_INFO

SAL_GRADE_CD

Salary grade code

N

Functional Job Title via CP Job Template

EMPL_LAB_INFO

SEASON_EMPL_FL

Seasonal employee

N

CP Job Template, Hardcoded

EMPL_LAB_INFO

SEC_ORG_ID

Security organization ID

Y

CP Job Template, Org

EMPL_LAB_INFO

SPVSR_EMPL_ID

Supervisor employee ID

N

user_manager_id, CP Job Template

EMPL_LAB_INFO

STD_EFFECT_AMT

Standard effective hourly rate

N

N/A

EMPL_LAB_INFO

STD_EST_HRS

Standard estimated annual hours

N

CP Job Template

EMPL_LAB_INFO

TC_TS_SCHED_CD

Time Collection timesheet schedule

N

CP Job Template

EMPL_LAB_INFO

TC_WORK_SCHED_CD

Time Collection work schedule

N

CP Job Template, Labor Settings

EMPL_LAB_INFO

TERM_DT_FL

Effective term date flag (Y/N)

N

N/A

EMPL_LAB_INFO

TIME_STAMP

Date and time of row creation or last modification

N

N/A

EMPL_LAB_INFO

TITLE_DESC

Position title

N

job_title, Detail Job Titles table, or CP Job Template

EMPL_LAB_INFO

TRN_CRNCY_CD

Currency

Y (if licensed for Multicurrency and the Enable Multi-Currency Functionality check box is selected on the Configure Labor Setting screen.

CP Job Template, GL Settings

EMPL_LAB_INFO

WORK_STATE_CD

Overtime state code (for OT Calculations)

Y (for first record only)

user_state_abbreviation

EMPL_LAB_INFO

REQ_NO

Requirement number

N

N/A

EMPL_LAB_INFO

WORK_YR_HRS_NO

Work hours in year

Y

CP Job Template