GVT_NOAC_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
2	GVT_NOA_CODE	Character(3)	VARCHAR2(3) NOT NULL	Nature of Action Code
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR25	Character(25)	VARCHAR2(25) NOT NULL	Short description
6	DESCR25_2	Character(25)	VARCHAR2(25) NOT NULL	Description part 2
7	EFFECTIVE_TIME	Character(1)	VARCHAR2(1) NOT NULL	Time NOA is Effective C=Close of Business Day O=Opening of Business Day Default Value: O
8	GVT_CPDF_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required for CPDF Y/N Table Edit Default Value: Y
9	GVT_NOA_PAR_PUSH	Character(1)	VARCHAR2(1) NOT NULL	Push Action to Job Y/N Table Edit Default Value: Y
10	GVT_IRR_REPORTABLE	Character(1)	VARCHAR2(1) NOT NULL	IRR Reporting Settings Y/N Table Edit Default Value: N
11	GVT_IRR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	IRR Type based on NOAC A=Final Disability C=Correction D=Death M=Military Deposit N=Not Applicable P=Preliminary Disability R=Retirement S=Supplemental T=Transfer/Resignation
12	GVT_NOAC_PA_APRVL	Character(1)	VARCHAR2(1) NOT NULL	stores NOA code configuration for position administrator approval requirement. Y/N Table Edit Default Value: N
13	GVT_NOAC_SKIP_LVL	Character(1)	VARCHAR2(1) NOT NULL	To store NOA Code configuration for Skip approval levels. Y/N Table Edit Default Value: N