ADM_APPL_MATLS

(SQL Table)
 Index Back

Admission Applicant Materials

This record links Admission Applications to general materials, external academic transcripts, external academic summaries, external subjects, and external courses for use in an evaluation and/or determining completeness of an application.

  • Parent record: ADM_APP_CAR_SEQ

    • # 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 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

    Prompt Table: STDNT_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr

    Prompt Table: ADM_APPL_DATA

    5 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr

    Prompt Table: ADM_APP_CAR_SEQ

    6 GENL_MATL_GROUP Character(8) VARCHAR2(8) NOT NULL Material Group

    Prompt Table: MATL_GRP_TBL

    7 GENL_MATL_TYPE Character(3) VARCHAR2(3) NOT NULL Material Type

    Prompt Table: MATL_GRPTYP_TBL

    8 GENL_MATL_NBR Number(3,0) SMALLINT NOT NULL Material Nbr

    Prompt Table: GENL_MATERIALS

    9 APPL_MATL_NBR Number(3,0) SMALLINT NOT NULL Appl Matl Nbr
    10 MATL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Material Indicator

    Y/N Table Edit

    Default Value: N

    11 MATL_USAGE Character(4) VARCHAR2(4) NOT NULL Material Usage
    BOTH=Both
    COMP=Completion
    EVAL=Evaluation
    12 USED_IN_RATING Character(1) VARCHAR2(1) NOT NULL Used to Determine Rating

    Y/N Table Edit

    Default Value: N

    13 TEST_ID Character(11) VARCHAR2(11) NOT NULL Test ID
    14 TEST_COMPONENT Character(5) VARCHAR2(5) NOT NULL Test Component
    15 TEST_DT Date(10) DATE Test Date
    16 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
    17 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score
    18 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External Academic Level
    0=Unknown
    01=Pre-Eighth Grade
    1=Eighth Grade
    2=Ninth Grade
    3=Tenth Grade
    4=Eleventh Grade
    5=Twelfth Grade
    6=Postsecondary First Year
    7=Postsecondary Sophomore
    8=Postsecondary Junior
    9=Postsecondary Senior
    90=Post-Secondary
    91=Postsecondary Professional
    92=Postsecondary Master
    93=Postsecondary Doctoral
    94=Postdoctoral
    A1=Basic User/Breakthrough (NLD)
    A2=Basic User/Waystage (NLD)
    B1=Independ. User/Threshold (NLD)
    B2=Independ. User/Vantage (NLD)
    C1=Prof. User/Effective (NLD)
    C2=Proficient User/Master (NLD)
    19 DATE_LOADED Date(10) DATE Date Loaded
    20 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
    21 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    22 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate
    23 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
    24 EXT_SUMM_TYPE Character(4) VARCHAR2(4) NOT NULL Summary Type
    25 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
    OFF=Official
    UNO=Unofficial
    26 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    27 TRANSCRIPT_DT Date(10) DATE Transcript Date
    28 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
    D=Desired
    R=Received

    Default Value: D

    29 RECEIVED_DT Date(10) DATE Certificate Received Date
    30 DATA_MEDIUM Character(1) VARCHAR2(1) NOT NULL Data Medium
    E=EDI
    H=Hard Copy
    31 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    32 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown
    33 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
    FALL=Fall
    SPR=Spring
    SUMR=Summer
    WINT=Winter
    34 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    35 UNT_TYPE Character(3) VARCHAR2(3) NOT NULL Unit Type
    ADU=Adult
    CAR=Carnegie Units
    CEU=Continuing Education Unit
    NCR=No Credit
    OTH=Non-Standard units
    QTR=Quarter Units
    SEM=Semester Units
    UKN=Unknown
    UNT=Units
    VOC=Vocational
    36 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
    37 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
    38 CLASS_RANK Number(5,0) INTEGER NOT NULL Class Rank
    39 CLASS_SIZE Number(5,0) INTEGER NOT NULL Class Size
    40 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type
    41 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA
    42 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA
    43 RANK_TYPE Character(3) VARCHAR2(3) NOT NULL Rank Type
    UNW=Unweighted
    WGT=Weighted
    44 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
    45 EXT_CRSE_TYPE Character(3) VARCHAR2(3) NOT NULL External Course Type
    C=Challenge
    CRS=Course
    E=Equivalency
    EVT=Event or Summary
    N/A=Course - Not Applicable
    REP=Course - Repeated
    WTH=Course - Withdrawn
    46 BEGIN_DT Date(10) DATE Begin Date
    47 END_DT Date(10) DATE end date
    48 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    49 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    50 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)
    51 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
    11=Grade 11
    12=Grade 12
    AP=Advanced Placement
    DR=Graduate/Doctoral
    FR=Freshman
    GR=Graduate
    HN=Honors
    IB=International Baccalaureate
    JR=Junior
    LD=Lower Division
    MS=Graduate/Master
    RG=Regular
    SO=Sophomore
    SR=Senior
    UD=Upper Division
    52 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    53 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    54 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject
    55 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr
    56 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area
    57 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed
    58 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted