GP_HIST_ELEM

(SQL Table)
Index Back

Historical Element Record

Historical Elements Mapping Record

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 ENTRY_TYPE_HR1 Character(3) VARCHAR2(3) NOT NULL Entry Type - Historical Data

Prompt Table: GP_ENT_HR0_VW

5 PIN_CURPRD_NUM Number(8,0) INTEGER NOT NULL Current Period Element

Prompt Table: %GP_EDIT_FLD4

6 PIN_HISTPRD_NUM Number(8,0) INTEGER NOT NULL Historical Period Element Number

Prompt Table: %GP_EDIT_FLD3

7 SUM_SLICES_IND Character(1) VARCHAR2(1) NOT NULL Sum Slices or Use Last Slice indicator for Historical Rule
1=Sum Slices
2=Use Last Slice
3=Sum Slices - Current Empl Rcd
4=Use Last Slice - Cur. Empl Rcd

Default Value: 2