GVT_MOC_DATA

(SQL Table)
Index Back

Mass Org Change Data

Mass Org Change Data Setup Data

  • Related Language Record: GVT_MOC_DTA_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MOC_ID Character(5) VARCHAR2(5) NOT NULL Mass Organization Change ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ASOFDATE Date(10) DATE NOT NULL As of Date

    Default Value: %date

    5 GVT_NOA_CODE Character(3) VARCHAR2(3) NOT NULL Nature of Action Code

    Prompt Table: GVT_NOAC_TBL

    6 GVT_LEG_AUTH_1 Character(3) VARCHAR2(3) NOT NULL Legal Authority (1)

    Prompt Table: GVT_AUTH_VAL_1

    7 GVT_PAR_AUTH_D1 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 1
    8 GVT_PAR_AUTH_D1_2 Character(25) VARCHAR2(25) NOT NULL Authority 1 Descr - Part 2
    9 GVT_WIP_STATUS Character(3) VARCHAR2(3) NOT NULL Work-in-Progress Status

    Prompt Table: GVT_WIP_STATUS

    10 NEW_DEPTID Character(10) VARCHAR2(10) NOT NULL New Department

    Prompt Table: DEPT_TBL

    11 NEW_POS_NBR Character(8) VARCHAR2(8) NOT NULL New Position

    Prompt Table: POSITION_DATA

    12 ACTION Character(3) VARCHAR2(3) NOT NULL Action

    Default Value: XFR

    Prompt Table: ACTION_TBL

    13 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

    Prompt Table: ACTN_REASON_TBL

    14 SELECTOR Character(1) VARCHAR2(1) NOT NULL To indicate which field to chg
    D=Department
    P=Position

    Default Value: D

    15 DELETE_DATA Character(1) VARCHAR2(1) NOT NULL Clear Data in Temp Table

    Y/N Table Edit

    Default Value: Y

    16 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number

    Prompt Table: POSITION_DATA