GPSC_ELM_AC_MBR

(SQL View)
 Index Back

GP Accumulator Members

This record contains the elements that contribute to a given Accumulator

SELECT PIN_NUM , PIN_MBR_NUM , BGN_DT , END_DT , ENTRY_TYPE_ELEM , ACM_SIGN , ENTRY_TYPE_PCT , PCT_TO_ACM , PIN_PCT_NUM FROM PS_GP_ACM_MBR WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , PIN_MBR_NUM , BGN_DT , END_DT , ENTRY_TYPE_ELEM , ACM_SIGN , ENTRY_TYPE_PCT , PCT_TO_ACM , PIN_PCT_NUM FROM PS_GPSC_RM_AC_MBR 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 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD7

3 BGN_DT Date(10) DATE NOT NULL Begin Date
4 END_DT Date(10) DATE end date
5 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_NUMER_VW

6 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract
7 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Prompt Table: GP_ENT_PCTAC_VW

8 PCT_TO_ACM Number(10,6) DECIMAL(9,6) NOT NULL Percent to Accumulate
9 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: %GP_EDIT_FLD8