GP_ACM1_VW

(SQL View)
Index Back

Accumulator View

Record view of GP Accumulators

SELECT PIN_NUM , PYE_RCDN_KEY_IND , ENTRY_TYPE_USER_K1 , PIN_USER_KEY1_NUM , ENTRY_TYPE_USER_K2 , PIN_USER_KEY2_NUM , ENTRY_TYPE_USER_K3 , PIN_USER_KEY3_NUM , ENTRY_TYPE_USER_K4 , PIN_USER_KEY4_NUM , ENTRY_TYPE_USER_K5 , PIN_USER_KEY5_NUM , ENTRY_TYPE_USER_K6 , PIN_USER_KEY6_NUM , ACM_TIMING_OPTN , ACM_BASIS_OPTN , ENTRY_TYPE_BASIS , PIN_BASIS_DT_NUM , BASIS_DT , CORR_RTO_IND , PIN_ACM_FRML_NUM , NUM_MTHS_AFTER_END , ACM_PRD_OPTN , ACM_BGN_OPTN , BGN_MTH_OPTN , PIN_BGN_MTH_NUM , BGN_MTH , BGN_DAY_OPTN , PIN_BGN_DAY_NUM , BGN_DAY , ENTRY_TYPE_DT , PIN_BGN_DT_NUM , BGN_DT , GP_VERSION FROM PS_GP_ACCUMULATOR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 PYE_RCDN_KEY_IND Character(1) VARCHAR2(1) NOT NULL accumulator level - this is the same as the ACM TYPE field
N=Payee (EMPLID)
Y=Job (EMPLID/EMPL_RCD)

Y/N Table Edit

3 ENTRY_TYPE_USER_K1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

4 PIN_USER_KEY1_NUM Number(8,0) INTEGER NOT NULL Element number field
5 ENTRY_TYPE_USER_K2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

6 PIN_USER_KEY2_NUM Number(8,0) INTEGER NOT NULL Element number field
7 ENTRY_TYPE_USER_K3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

8 PIN_USER_KEY3_NUM Number(8,0) INTEGER NOT NULL Element number field
9 ENTRY_TYPE_USER_K4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

10 PIN_USER_KEY4_NUM Number(8,0) INTEGER NOT NULL Element number field
11 ENTRY_TYPE_USER_K5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

12 PIN_USER_KEY5_NUM Number(8,0) INTEGER NOT NULL Element number field
13 ENTRY_TYPE_USER_K6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENTRY_TYPE

14 PIN_USER_KEY6_NUM Number(8,0) INTEGER NOT NULL Element number field
15 ACM_TIMING_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Timing
1=As Contributing
2=As Accumulator Is Encountered
3=At End of Calculation

Default Value: 3

16 ACM_BASIS_OPTN Character(1) VARCHAR2(1) NOT NULL Allows user to determine whether a given period accumulator (balance) should be selected based on the Period Begin, End or Payment Date for the calendar its processed in.
B=Period Begin Date
E=Period End Date
P=Payment Date
S=Specified Date

Default Value: E

17 ENTRY_TYPE_BASIS Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 3

Prompt Table: GP_ENT_DATE_VW

18 PIN_BASIS_DT_NUM Number(8,0) INTEGER NOT NULL Element number field
19 BASIS_DT Date(10) DATE Basis -- Specify Date
20 CORR_RTO_IND Character(1) VARCHAR2(1) NOT NULL Use Corrective Retro

Y/N Table Edit

Default Value: N

21 PIN_ACM_FRML_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRM_R_VW

22 NUM_MTHS_AFTER_END Number(3,0) SMALLINT NOT NULL Number of Months

Default Value: 0

23 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
24 ACM_BGN_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Date Option
C=Use Pay Entity Calendar
F=Use Pay Entity Fiscal
S=Specify Date
25 BGN_MTH_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Month Option
C=Month
P=Variable

Default Value: C

26 PIN_BGN_MTH_NUM Number(8,0) INTEGER NOT NULL Element number field
27 BGN_MTH Character(2) VARCHAR2(2) NOT NULL Begin Month
01=January
02=February
03=March
04=April
05=May
06=June
07=July
08=August
09=September
10=October
11=November
12=December
28 BGN_DAY_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Day Option
N=Number
P=Variable

Default Value: N

29 PIN_BGN_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field
30 BGN_DAY Number(2,0) SMALLINT NOT NULL Begin Day
31 ENTRY_TYPE_DT Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Default Value: 003

Prompt Table: GP_ENT_DATE_VW

32 PIN_BGN_DT_NUM Number(8,0) INTEGER NOT NULL Element number field
33 BGN_DT Date(10) DATE Begin Date
34 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.