GPSC_ELM_ACCUM

(SQL View)
 Index Back

GP Accumulator Definition

GP Accumulator Definition

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 , CALC_TYPE , 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 , END_IF_ZERO_IND , CUSTOM_MTHS , GP_VERSION FROM PS_GP_ACCUMULATOR WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION 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 , CALC_TYPE , 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 , END_IF_ZERO_IND , CUSTOM_MTHS , GP_VERSION FROM PS_GPSC_RM_ACCUM 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 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)
3 ENTRY_TYPE_USER_K1 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

4 PIN_USER_KEY1_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD1

5 ENTRY_TYPE_USER_K2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

6 PIN_USER_KEY2_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD2

7 ENTRY_TYPE_USER_K3 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

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

Prompt Table: %GP_EDIT_FLD3

9 ENTRY_TYPE_USER_K4 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

10 PIN_USER_KEY4_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD4

11 ENTRY_TYPE_USER_K5 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

12 PIN_USER_KEY5_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD5

13 ENTRY_TYPE_USER_K6 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_USERK_VW

14 PIN_USER_KEY6_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD6

15 ACM_TIMING_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Timing
1=As Contributing Member
2=As Accumulator Is Encountered
3=At End of Calculation
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
17 ENTRY_TYPE_BASIS Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_DATE_VW

18 PIN_BASIS_DT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD7

19 BASIS_DT Date(10) DATE Basis -- Specify Date
20 CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Calculation Process Type. Identifies a run as either absence run or payroll run
A=Absence Calculation
B=All Calculations
P=Payroll Calculation
21 CORR_RTO_IND Character(1) VARCHAR2(1) NOT NULL Use Corrective Retro

Y/N Table Edit

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

Prompt Table: GP_PIN_FM_VW

23 NUM_MTHS_AFTER_END Number(3,0) SMALLINT NOT NULL Number of Months
24 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
25 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
26 BGN_MTH_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Month Option
C=Month
P=Variable
27 PIN_BGN_MTH_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_VAR_N_VW

28 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
29 BGN_DAY_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Day Option
N=Number
P=Variable
30 PIN_BGN_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_VAR_N_VW

31 BGN_DAY Number(2,0) SMALLINT NOT NULL Begin Day
32 ENTRY_TYPE_DT Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_DATE_VW

33 PIN_BGN_DT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD8

34 BGN_DT Date(10) DATE Begin Date
35 END_IF_ZERO_IND Character(1) VARCHAR2(1) NOT NULL This Y/N checkbox determines if the end date of a custom accumulator should be set to the period end date in which its value goes to zero.

Y/N Table Edit

36 CUSTOM_MTHS Number(3,0) SMALLINT NOT NULL This field contains the number of months that a Custom Accumulator will remain in force.
37 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.