GPSC_ELM_ED_AGA

(SQL View)
 Index Back

Autogenerated Element Defaults

Record for GP Autogenerated Element Defaults This table contains a row for each Earning, Deduction and Absence Entitlement element with information that drives the generation of component elements and accumulators associated with each parent Earning, Deduction and Absence Entitlement

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 , ACM_PRD_OPTN , ACM_BGN_OPTN , ENTRY_TYPE_DT , BGN_DT , PIN_BGN_DT_NUM , BGN_MTH_OPTN , BGN_MTH , PIN_BGN_MTH_NUM , BGN_DAY_OPTN , BGN_DAY , PIN_BGN_DAY_NUM , COUNTRY , PTD_AMT_IND , PTD_UNIT_IND , PTD_AMT_IND_FSCL , PTD_UNIT_IND_FSCL , MTD_AMT_IND , MTD_UNIT_IND , MTD_AMT_IND_FSCL , MTD_UNIT_IND_FSCL , QTD_AMT_IND , QTD_UNIT_IND , QTD_AMT_IND_FSCL , QTD_UNIT_IND_FSCL , YTD_AMT_IND , YTD_UNIT_IND , YTD_AMT_IND_FSCL , YTD_UNIT_IND_FSCL , BAL_UNIT_IND , ENTL_UNIT_IND , ADJ_UNIT_IND , TAKE_UNIT_IND , START_DT_IND_AUTO , GP_VERSION FROM PS_GP_AUTOGEN_DFLT 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 , ACM_PRD_OPTN , ACM_BGN_OPTN , ENTRY_TYPE_DT , BGN_DT , PIN_BGN_DT_NUM , BGN_MTH_OPTN , BGN_MTH , PIN_BGN_MTH_NUM , BGN_DAY_OPTN , BGN_DAY , PIN_BGN_DAY_NUM , COUNTRY , PTD_AMT_IND , PTD_UNIT_IND , PTD_AMT_IND_FSCL , PTD_UNIT_IND_FSCL , MTD_AMT_IND , MTD_UNIT_IND , MTD_AMT_IND_FSCL , MTD_UNIT_IND_FSCL , QTD_AMT_IND , QTD_UNIT_IND , QTD_AMT_IND_FSCL , QTD_UNIT_IND_FSCL , YTD_AMT_IND , YTD_UNIT_IND , YTD_AMT_IND_FSCL , YTD_UNIT_IND_FSCL , BAL_UNIT_IND , ENTL_UNIT_IND , ADJ_UNIT_IND , TAKE_UNIT_IND , START_DT_IND_AUTO , GP_VERSION FROM PS_GPSC_RM_AG_DFLT 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_FLD6

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_FLD7

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_FLD8

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_FLD9

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_FLD11

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_FLD12

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_FLD10

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 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
23 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
24 ENTRY_TYPE_DT Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_DATE_VW

25 BGN_DT Date(10) DATE Begin Date
26 PIN_BGN_DT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD4

27 BGN_MTH_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Month Option
C=Month
P=Variable
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 PIN_BGN_MTH_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_VAR_N_VW

30 BGN_DAY_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Day Option
N=Number
P=Variable
31 BGN_DAY Number(2,0) SMALLINT NOT NULL Begin Day
32 PIN_BGN_DAY_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_VAR_N_VW

33 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: GP_COUNTRY_VW

34 PTD_AMT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar PTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

35 PTD_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar PTD accumulator should be generated for the units recorded with a given earning or deduction.

Y/N Table Edit

36 PTD_AMT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a fiscal PTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

37 PTD_UNIT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a fiscal PTD accumulator should be generated the units of a given earning or deduction.

Y/N Table Edit

38 MTD_AMT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar MTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

39 MTD_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar MTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

40 MTD_AMT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal MTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

41 MTD_UNIT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal Units MTD accumulator should be generated for a given earning, deduction or absence.

Y/N Table Edit

42 QTD_AMT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar QTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

43 QTD_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a calendar QTD units accumulator should be generated for a given earning or deduction.

Y/N Table Edit

44 QTD_AMT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal QTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

45 QTD_UNIT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal QTD units accumulator should be generated for a given earning or deduction.

Y/N Table Edit

46 YTD_AMT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Calendar YTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

47 YTD_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Calendar YTD units accumulator should be generated for a given earning or deduction.

Y/N Table Edit

48 YTD_AMT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal YTD accumulator should be generated for a given earning or deduction.

Y/N Table Edit

49 YTD_UNIT_IND_FSCL Character(1) VARCHAR2(1) NOT NULL Y/N. Indicate whether a Fiscal YTD Units accumulator should be generated for a given earning or deduction.

Y/N Table Edit

50 BAL_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicate whether to generate an accumulator to track balance of units for a given absence

Y/N Table Edit

51 ENTL_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates whether an accumulator to track units entitled (accrued) should be generated for a given absence entitlement

Y/N Table Edit

52 ADJ_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates whether an accumulator to track units adjusted should be generated for a given absence entitlement

Y/N Table Edit

53 TAKE_UNIT_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicates whether an accumulator to track units taken as paid should be generated for a given absence entitlement

Y/N Table Edit

54 START_DT_IND_AUTO Character(1) VARCHAR2(1) NOT NULL Pay Entity Calendar

Y/N Table Edit

55 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.