ERN_PROGRAM_DEF (SQL Table)	Index Back
Earnings Codes for Earn Pgm This record is used to define the set of earnings types associated with an earnings program. When you set up an earnings program, you are defining which earnings types will be valid for the pay groups that use the program, and hence which earnings types will be valid for employees belonging to those pay groups.

ERN_PROGRAM_DEF

(SQL Table)

Earnings Codes for Earn Pgm

This record is used to define the set of earnings types associated with an earnings program. When you set up an earnings program, you are defining which earnings types will be valid for the pay groups that use the program, and hence which earnings types will be valid for employees belonging to those pay groups.

Parent record: ERN_PROGRAM_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ERN_PROGRAM Character(3) VARCHAR2(3) NOT NULL Earnings Program ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ERN_PROGRAM	Character(3)	VARCHAR2(3) NOT NULL	Earnings Program ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	ERNCD	Character(3)	VARCHAR2(3) NOT NULL	Earnings Code Prompt Table: EARNINGS_TBL