GVT_NOAC_TBL

(SQL Table)
Index Back

Nature of Action Code Table

  • Related Language Record: GVT_NOAC_LANG
  • # 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