CAN_EXT_ACAD_DA

(SQL Table)
 Index Back

CAN External Academic Data

Canadian fields.

  • Parent record: EXT_ACAD_DATA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: EXT_ACAD_DATA.EXT_ORG_ID

    Prompt Table: EXT_ORG_TBL

    3 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate

    Default Value: EXT_ORG_TBL_ADM.EXT_CAREER

    4 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

    Default Value: 1

    6 CAN_ESIS_PREV_ACT Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
    7 CAN_ESIS_PREV_CRED Character(2) VARCHAR2(2) NOT NULL SAC-R75-19990831
    01=General Equivalancy Diploma
    02=Certificate
    03=Diploma
    04=Degree
    05=Declaration of Achievement
    06=Other College PostSecondary
    07=Other College Non-PostSecond
    08=Other Undergraduate Credential
    09=Other Graduate Credential
    96=Other Type of Credential
    98=Not Applicable
    99=Unknown