GPSC_RM_AC_MBR

(SQL Table)
Index Back

Remote Accumulator Members

Remote Accumulator Members

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Default Value: 99999999

2 PIN_MBR_NUM Number(8,0) INTEGER NOT NULL Element number field

Default Value: 99999999

Prompt Table: %GP_EDIT_FLD7

3 BGN_DT Date(10) DATE NOT NULL Begin Date

Default Value: %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

Default Value: A

7 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Default Value: 002

Prompt Table: GP_ENT_PCTAC_VW

8 PCT_TO_ACM Number(10,6) DECIMAL(9,6) NOT NULL Percent to Accumulate

Default Value: 100

9 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: %GP_EDIT_FLD8