AV_INTV_UNIT

(SQL Table)
Index Back

Initiative Unit

Allows the user to link the initiative to a Unit defined within Advancement that may not coincide with the departmental structure for the institution. ======================================================== 5/14/01 (JPM) - Removed AV_INTV_TBL.END_DT as default value for END_DT. Removed %Date as a default value from START_DT. ========================================================

  • Parent record: AV_INTV_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code

    Prompt Table: AV_INTV_TBL

    3 UNIT_CD Character(11) VARCHAR2(11) NOT NULL Unit Code

    Prompt Table: AV_UNIT_TBL

    4 PURPOSE_CD Character(3) VARCHAR2(3) NOT NULL Role

    Prompt Table: %EDITTABLE4

    5 START_DT Date(10) DATE NOT NULL Start Date
    6 END_DT Date(10) DATE end date