UPG_AD801_AET

(SQL Table)
 Index Back

Admission Interests

ADM_INTERESTS tracks Academic Interests that may be indicated by an admission candidate or prospect but not necessarily offered as a plan or subplan by a particular Academic Program.

  • Parent record: ADM_INTRST_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPLID_OLD Character(11) VARCHAR2(11) NOT NULL Previous Employee ID
    4 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    5 ACAD_CAREER_OLD Character(4) VARCHAR2(4) NOT NULL Academic Career
    6 EFFDT Date(10) DATE Effective Date
    7 EFFDT_OLD Date(10) DATE Old Effective Date
    8 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
    A8=TEAS Degree Information
    AAD=AADSAS
    ACT=American College Testing
    AE=Ad-Hoc Employee
    AMC=AMCAS
    AO=Ad-Hoc Organizational
    E=Extract
    ETS=Educational Testing Service
    GH=OLSAS Last Secondary-G2
    LSD=LSDAS
    PI=Prev/Post Secondary Info
    RS=OLSAS Postsecondary Info
    SCH=School
    SLF=Self-Reported Information
    WWW=World Wide Web
    11 PRIORITY Number(3,0) SMALLINT NOT NULL Priority
    12 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    13 STDNT_CAR_NBR1 Number(3,0) SMALLINT NOT NULL Student Career Number
    14 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    15 ADM_APPL_NBR_OLD Character(8) VARCHAR2(8) NOT NULL Application Nbr
    16 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    17 RESPONSE_REASON Character(4) VARCHAR2(4) NOT NULL Response Reason
    18 RESPONSE_DT Date(10) DATE Response Date
    19 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    20 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
    21 TEST_DT Date(10) DATE Test Date
    22 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    23 TEST_NBR Number(2,0) SMALLINT NOT NULL Test Number
    24 SAD_TEST_DT_LD Character(10) VARCHAR2(10) NOT NULL Test Load Test Date
    25 LSDAS_UPPER_BAND Number(3,0) SMALLINT NOT NULL LSDAS Upper Band
    26 LSDAS_LOWER_BAND Number(3,0) SMALLINT NOT NULL LSDAS Lower Band
    27 IRREG_CD_LSAC Character(1) VARCHAR2(1) NOT NULL LSAC Irregularity Code