GP_PKG_AT1_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Default Value: 999999
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	ABS_TYPE_OPTN	Character(3)	VARCHAR2(3) NOT NULL	Absence Type
5	TAKE_CONFIG1	Character(10)	VARCHAR2(10) NOT NULL	Field reserved for custom attribution to an Absence Take
6	TAKE_CONFIG2	Character(10)	VARCHAR2(10) NOT NULL	Field reserved for custom attribution to an Absence Take
7	TAKE_CONFIG3	Character(10)	VARCHAR2(10) NOT NULL	Field reserved for custom attribution to an Absence Take
8	TAKE_CONFIG4	Character(10)	VARCHAR2(10) NOT NULL	Field reserved for custom attribution to an Absence Take
9	MGR_APPR_REQ_IND	Character(1)	VARCHAR2(1) NOT NULL	Manager Approval Required Y/N Table Edit Default Value: N
10	MULTIPLE_INST_IND	Character(1)	VARCHAR2(1) NOT NULL	Multiple Instances Y/N Table Edit Default Value: Y
11	PIN_BAL_OFFSET_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
12	ENTRY_TYPE_FROM	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date From Element Default Value: 003 Prompt Table: GP_ENT_DATE_VW
13	DATE_FROM	Date(10)	DATE	Date From
14	PIN_DATE_FROM_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period Date From Element
15	ENTRY_TYPE_TO	Character(3)	VARCHAR2(3) NOT NULL	Entry Type for Date To Element Default Value: 003 Prompt Table: GP_ENT_DATE_VW
16	DATE_TO	Date(10)	DATE	Previous Period Date To
17	PIN_DATE_TO_NUM	Number(8,0)	INTEGER NOT NULL	Previous Period To Date Element
18	PIN_LINKED_TO_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
19	PIN_LINK_COND_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
20	PIN_DAY_FM_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
21	ENTRY_TYPE_ELEM	Character(3)	VARCHAR2(3) NOT NULL	entry type element Default Value: 003 Prompt Table: GP_ENT_DATE_VW
22	ELIG_PRD_IND	Character(1)	VARCHAR2(1) NOT NULL	Eligibility Y/N Table Edit Default Value: N
23	ELIG_DATE	Date(10)	DATE	Eligibility Date Value
24	PIN_ELIG_DATE_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
25	ENTRY_TYPE_ELEM2	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Default Value: 002 Prompt Table: GP_ENT_ABS3_VW
26	MIN_PRD_IND	Character(1)	VARCHAR2(1) NOT NULL	Minimum Absence Y/N Table Edit Default Value: N
27	PIN_MIN_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
28	MIN_PRD_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Minimum Period Value
29	ENTRY_TYPE_ELEM3	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Default Value: 002 Prompt Table: GP_ENT_ABS3_VW
30	WAIT_PRD_IND	Character(1)	VARCHAR2(1) NOT NULL	Wait Per Absence Y/N Table Edit Default Value: N
31	PIN_WAIT_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
32	WAIT_PRD_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Wait Period Value
33	PIN_WAIT_CNT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
34	ENTRY_TYPE_ELEM4	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Default Value: 002 Prompt Table: GP_ENT_ABS3_VW
35	LINK_PRD_IND	Character(1)	VARCHAR2(1) NOT NULL	Link Absence Y/N Table Edit Default Value: N
36	PIN_LINK_PRD_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
37	LINK_PRD_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Link Period Value
38	LINK_FROM_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Starting From E=End Date of Last Occurrence F=Start Date of 1st Occurrence Default Value: E
39	LINK_PRD_UNIT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Linked Within Absence Unit Opt D=Days M=Months W=Weeks Default Value: D
40	SAME_ABSENCE_IND	Character(1)	VARCHAR2(1) NOT NULL	By Original Begin Date Y/N Table Edit Default Value: N
41	ENTRY_TYPE_ELEM5	Character(3)	VARCHAR2(3) NOT NULL	Entry (element) type field Prompt Table: GP_ENT_ABS2_VW
42	NEG_BAL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Negative Balance Option A=Allow Negative Balance O=Take with Other Absence U=Take as Unpaid Time Default Value: A
43	NEG_LMT_VAL	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	Negative Limit Value
44	PIN_NEG_ABS_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
45	PIN_NEG_LMT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
46	EVT_DUP_IND	Character(1)	VARCHAR2(1) NOT NULL	allow overlapping instances of absence 0=No Duplicates Allowed 1=Duplicates Ok Y/N Table Edit Default Value: N
47	EVT_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Event Priority
48	PIN_FCST_NUM	Number(8,0)	INTEGER NOT NULL	This field is used on the GP_ABS_TAKE definition to identify the forecast element to be resolved during forecasting for the event associated with that take.
49	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.