GPSC_ELM_ED_ACM (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).

GPSC_ELM_ED_ACM

(SQL View)

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 WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION 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_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_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 END_DT Date(10) DATE end date

6 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

7 ACM_SIGN Character(1) VARCHAR2(1) NOT NULL Accumulator Sign
A=Add
S=Subtract

8 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option
Prompt Table: GP_ENT_PCTAC_VW

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

10 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element
Prompt Table: %GP_EDIT_FLD10

#	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	END_DT	Date(10)	DATE	end date
6	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element
7	ACM_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Accumulator Sign A=Add S=Subtract
8	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option Prompt Table: GP_ENT_PCTAC_VW
9	PCT_TO_ACM	Number(10,6)	DECIMAL(9,6) NOT NULL	Percent to Accumulate
10	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element Prompt Table: %GP_EDIT_FLD10