GP_PKG_HR2_VW

(SQL View)
 Index Back

Historic Data Rule

Historic Data Rule

SELECT PIN_NUM + 50000000 , EFFDT , EFF_STATUS , HIST_RULE_TYPE , ENTRY_TYPE_FROM , DATE_FROM , PIN_DATE_FROM_NUM , ENTRY_TYPE_TO , DATE_TO , PIN_DATE_TO_NUM , PREV_PRD_PRT_TYPE , PIN_FRML_PRD_NUM , PIN_STOP_PROC_NUM , PIN_FRML_END_NUM , PIN_USE_PRD_NUM , DEBUG_SQL_OPT , GP_VERSION FROM PS_GP_HIST_RULE

# 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

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
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
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
12 PIN_FRML_PRD_NUM Number(8,0) INTEGER NOT NULL Formula NUmber to exedcute by Period
13 PIN_STOP_PROC_NUM Number(8,0) INTEGER NOT NULL Element Number to Continue Process
14 PIN_FRML_END_NUM Number(8,0) INTEGER NOT NULL Formula Number to execute at the end of Process
15 PIN_USE_PRD_NUM Number(8,0) INTEGER NOT NULL Element number field
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.