GP_ACM1_VW

#	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.