GP_PKG_HR2_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	HIST_RULE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Historic Rule Type can be either Fictitious or Historic 1=Retrieve Values 2=Use in Fictitious Calculation
6	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element
7	DATE_FROM	Date(10)	DATE	Date From
8	PIN_DATE_FROM_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period Date From Element
9	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element
10	DATE_TO	Date(10)	DATE	Previous Period Date To
11	PIN_DATE_TO_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period To Date Element
12	PREV_PRD_PRT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Previous Period Mismatch Option 1=Period End Date 2=Payment Date 3=Period Begin Date
13	PIN_FRML_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Formula NUmber to exedcute by Period
14	PIN_STOP_PROC_NUM	Number(8,0)	INTEGER NOT NULL	Element Number to Continue Process
15	PIN_FRML_END_NUM	Number(8,0)	INTEGER NOT NULL	Formula Number to execute at the end of Process
16	PIN_USE_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
17	DEBUG_SQL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Dynamic SQL Debug Option N=No Debugging Y=Debug SQL
18	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.