DTYA_OR_AUS_LNG

(SQL Table)
Index Back

AUS Info on Organization Unit

This table contains fields required by Australian Higher Education (DETYA) to maintain organization units. This is the language record for DTYA_ORGUNT_AUS

  • Related Language Record for DTYA_ORGUNT_AUS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ORG_UNIT_AUS Character(4) VARCHAR2(4) NOT NULL This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description