GP_PKG_DR1_AD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GP_PKG_ID	Character(10)	VARCHAR2(10) NOT NULL	Field used for element packaging
2	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
3	EFFDT	Date(10)	DATE	Effective Date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element
6	DATE_FROM	Date(10)	DATE	Date From
7	PIN_DATE_FROM_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period Date From Element
8	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element
9	DATE_TO	Date(10)	DATE	Previous Period Date To
10	PIN_DATE_TO_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period To Date Element
11	RETURN_DECIMALS	Character(1)	VARCHAR2(1) NOT NULL	Return Duration With Decimals
12	PERIOD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Period Option D=Days M=Months Y=Years
13	ROUND_MONTH_IND	Character(1)	VARCHAR2(1) NOT NULL	Add 1 Year if >=
14	ROUND_MONTH_VAL	Number(2,0)	SMALLINT NOT NULL	Round Months Number
15	ROUND_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Add 1 Month if >=
16	ROUND_DAY_VAL	Number(2,0)	SMALLINT NOT NULL	Round Day Number
17	GNRN_STAT_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N indicates whether or not periods of time is included in the resolution of a duration element considers the payees employee status or not
18	DUR_EMPLSTAT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Used with Duration elements. Indicates whether to include or exclude days based on the payees HR status on the day. You can further indicate whether days should be included or excluded based on the time the payee was in that status. For example: - Always include days when payee was Active. - Include days when payee was suspended if he was in that status for less than a month. E=Excluded I=Included
19	INCL_DUR_LIMIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator to count Days 'Inclusive' or 'Exclusive' of the From and To Dates.
20	INCL_ABS_HIST_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Absence Days
21	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
22	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.