GPSC_ELM_FC_OD

(SQL View)
Index Back

Ficitious Calc Output Details

Ficitious Calc Output Details

SELECT PIN_NUM , EFFDT , FC_PERIOD , SEQ_NUM , PIN_CURPRD_NUM , PIN_FICTPRD_NUM FROM PS_GP_FC_OUT_DTL WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , FC_PERIOD , SEQ_NUM , PIN_CURPRD_NUM , PIN_FICTPRD_NUM FROM PS_GPSC_RM_FC_OPDT WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# 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 FC_PERIOD Number(3,0) SMALLINT NOT NULL Fictitious Calc Period Number
4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
5 PIN_CURPRD_NUM Number(8,0) INTEGER NOT NULL Current Period Element

Prompt Table: GP_PIN_VR0EL_VW

6 PIN_FICTPRD_NUM Number(8,0) INTEGER NOT NULL Prior Period Element

Prompt Table: GP_PIN_VR0_VW