AV_INTV_STAFF

(SQL Table)
Index Back

Initiative Staff

Additional Staff assigned to an Initiative. ======================================================== 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 STAFF_ID Character(11) VARCHAR2(11) NOT NULL Staff ID

    Prompt Table: AV_STAFF_STF_VW

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

    Prompt Table: %EDITTABLE

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