GVT_JOBERNS (SQL Table)	Index Back
EE Job Earnings JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee. GVT: Added GVT_SUB_AGENCY Added GVT_PAY_BASIS Added GVT_PY_PLAN Added GVT_BIWEEKLY_RT

GVT_JOBERNS

(SQL Table)

EE Job Earnings

JOB is one of the core records in the database. Use it to record an employee's job history data such as actions taken, department, job code, location, and salary history. You can create multiple JOB records for an employee. GVT: Added GVT_SUB_AGENCY Added GVT_PAY_BASIS Added GVT_PY_PLAN Added GVT_BIWEEKLY_RT

Parent record: PER_ORG_ASGN_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Default Value: NEW
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
Prompt Table: GVT_OTH_ERN_VW

6 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Default Value: NEW Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: GVT_OTH_ERN_VW
6	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.