GVT_NOAC_TBL(SQL Table) |
Index Back |
---|---|
Nature of Action Code Table |
# | 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 | Description - Part 1 |
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 above NOAC
A=Final Disability C=Correction D=Death M=Military Deposit N=Not Applicable P=Preliminary Disability R=Retirement S=Supplemental T=Transfer/Resignation |