GP_PKG_AGEN_VW (SQL View)	Index Back
Packaging View-AutoGen Default This is a Packaging View. It is used to move Autogenerated defaults for an Element between databases.

GP_PKG_AGEN_VW

(SQL View)

Packaging View-AutoGen Default

This is a Packaging View. It is used to move Autogenerated defaults for an Element between databases.

SELECT PIN_NUM + 50000000 , 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

# 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
Default Value: N

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

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

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

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

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

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

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

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

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

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

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

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

27 BGN_MTH_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Month Option
C=Month
P=Variable
Default Value: C

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

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

30 BGN_DAY_OPTN Character(1) VARCHAR2(1) NOT NULL Begin Day Option
N=Number
P=Variable
Default Value: N

31 BGN_DAY Number(2,0) SMALLINT NOT NULL Begin Day
Default Value: 1

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

33 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

54 START_DT_IND_AUTO Character(1) VARCHAR2(1) NOT NULL Pay Entity Calendar
Y/N Table Edit
Default Value: Y

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

#	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 Default Value: N
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
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
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
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
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
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
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
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
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 Default Value: N
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 Default Value: 6
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 Default Value: S
24	ENTRY_TYPE_DT	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Default Value: 003 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
27	BGN_MTH_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Begin Month Option C=Month P=Variable Default Value: C
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 Default Value: 01
29	PIN_BGN_MTH_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
30	BGN_DAY_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Begin Day Option N=Number P=Variable Default Value: N
31	BGN_DAY	Number(2,0)	SMALLINT NOT NULL	Begin Day Default Value: 1
32	PIN_BGN_DAY_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
33	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: N
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 Default Value: Y
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 Default Value: N
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 Default Value: N
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 Default Value: N
54	START_DT_IND_AUTO	Character(1)	VARCHAR2(1) NOT NULL	Pay Entity Calendar Y/N Table Edit Default Value: Y
55	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.