GVT_POSN_ERNS (SQL Table)	Index Back
Position Default Earnings Data This table is specific for the HR Federal Product. It is used to define the default earnings for a specific position. These earnings will be defined at the employee level on the GVT_JOB_ERNS table.

GVT_POSN_ERNS

(SQL Table)

Position Default Earnings Data

This table is specific for the HR Federal Product. It is used to define the default earnings for a specific position. These earnings will be defined at the employee level on the GVT_JOB_ERNS table.

Parent record: POSITION_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: 00000000

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

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

4 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	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Default Value: 00000000
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: ERN_PROGRAM_DEF
4	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.