GPSC_ELM_DR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE	Effective Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element Prompt Table: GP_ENT_DATE_VW
5	DATE_FROM	Date(10)	DATE	Date From
6	PIN_DATE_FROM_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period Date From Element Prompt Table: %GP_EDIT_FLD1
7	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element Prompt Table: GP_ENT_DATE_VW
8	DATE_TO	Date(10)	DATE	Previous Period Date To
9	PIN_DATE_TO_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period To Date Element Prompt Table: %GP_EDIT_FLD2
10	RETURN_DECIMALS	Character(1)	VARCHAR2(1) NOT NULL	Return Duration With Decimals Y/N Table Edit
11	PERIOD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Period Option D=Days M=Months Y=Years
12	ROUND_MONTH_IND	Character(1)	VARCHAR2(1) NOT NULL	Add 1 Year if >= Y/N Table Edit
13	ROUND_MONTH_VAL	Number(2,0)	SMALLINT NOT NULL	Round Months Number
14	ROUND_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	Add 1 Month if >= Y/N Table Edit
15	ROUND_DAY_VAL	Number(2,0)	SMALLINT NOT NULL	Round Day Number
16	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 Y/N Table Edit
17	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
18	INCL_DUR_LIMIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator to count Days 'Inclusive' or 'Exclusive' of the From and To Dates. Y/N Table Edit
19	INCL_ABS_HIST_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Absence Days Y/N Table Edit
20	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_FM2_VW
21	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.