GP_PKG_DR1_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Default Value: 999999
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element Default Value: 003 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
7	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element Default Value: 003 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
10	RETURN_DECIMALS	Character(1)	VARCHAR2(1) NOT NULL	Return Duration With Decimals Y/N Table Edit Default Value: N
11	PERIOD_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Period Option D=Days M=Months Y=Years Default Value: Y
12	ROUND_MONTH_IND	Character(1)	VARCHAR2(1) NOT NULL	Add 1 Year if >= Y/N Table Edit Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: I
18	INCL_DUR_LIMIT_IND	Character(1)	VARCHAR2(1) NOT NULL	Indicator to count Days 'Inclusive' or 'Exclusive' of the From and To Dates.
19	INCL_ABS_HIST_IND	Character(1)	VARCHAR2(1) NOT NULL	Include Absence Days
20	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
21	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.