GP_AUD_ED_AC_VW

(SQL View)
 Index Back

View of Accumulator Member rec

This is a view of the GP_ACM_MBR table where the PIN_NUM and PIN_MBR_NUM are switched in the view text. It provides a view of which accumulator elements use a given element (Earning/Deduction).

SELECT PIN_MBR_NUM , PIN_NUM , BGN_DT , PIN_NUM ,'' ,'' ,'' , END_DT , ENTRY_TYPE_ELEM , ACM_SIGN , ENTRY_TYPE_PCT , PCT_TO_ACM , PIN_PCT_NUM ,'' ,'' ,'' FROM PS_GP_ACM_MBR

# 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_FLD13

3 BGN_DT Date(10) DATE NOT NULL Begin Date
4 PIN_ACCUM_NUM Number(8,0) INTEGER NOT NULL Element number field
5 GP_AUD_CHAR_NM1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
6 GP_AUD_LINK1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
7 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
8 END_DT Date(10) DATE end date
9 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
10 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract
11 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Prompt Table: GP_ENT_PCTAC_VW

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

Prompt Table: %GP_EDIT_FLD10

14 GP_AUD_CHAR_NM2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
15 GP_AUD_LINK2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
16 GP_AUD_CHAR_VAL2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics