GPSC_RM_HR

#	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 NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	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 Default Value: 1
5	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element Prompt Table: GP_ENT_DATE_VW
6	DATE_FROM	Date(10)	DATE	Date From
7	PIN_DATE_FROM_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period Date From Element Prompt Table: %GP_EDIT_FLD1
8	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element Prompt Table: GP_ENT_DATE_VW
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 Prompt Table: %GP_EDIT_FLD2
11	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 Default Value: 2
12	PIN_FRML_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Formula NUmber to exedcute by Period Prompt Table: GP_PIN_FM0_VW
13	PIN_STOP_PROC_NUM	Number(8,0)	INTEGER NOT NULL	Element Number to Continue Process Prompt Table: GP_PIN_VR2EL_VW
14	PIN_FRML_END_NUM	Number(8,0)	INTEGER NOT NULL	Formula Number to execute at the end of Process Prompt Table: GP_PIN_FM0_VW
15	PIN_USE_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Element number field Prompt Table: GP_PIN_VR2EL_VW
16	DEBUG_SQL_OPT	Character(1)	VARCHAR2(1) NOT NULL	Dynamic SQL Debug Option N=No Debugging Y=Debug SQL
17	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.