ADM_TMP_MC

(SQL Table)
 Index Back

Adm/Comm Appl Data MC

ADM_APPL_DATA is used to record the basic information related to an admission application. It is possible to assign multiple applications to one person. It is also possible to have a multiple program application.

  • Parent record: STDNT_CAREER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
    2 MC_STATUS Character(3) VARCHAR2(3) NOT NULL Mass Change Status
    APR=Approved Transaction
    CAN=Cancel Transaction
    ERR=Errored Transaction
    PND=Pending Transaction
    SCS=Successful Transaction
    3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    5 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: ACAD_CAR_TBL

    6 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    7 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    8 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
    9 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    10 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    11 ADM_APPL_CTR Character(4) VARCHAR2(4) NOT NULL Application Center

    Default Value: OPR_DEF_TBL_CS.ADM_APPL_CTR

    Prompt Table: ADM_APPLCTR_VW

    12 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Default Value: OPR_DEF_TBL_CS.ADMIT_TYPE

    Prompt Table: ADMIT_TYPE_VW

    13 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

    Y/N Table Edit

    Default Value: N

    14 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing

    Default Value: H

    15 NOTIFICATION_PLAN Character(4) VARCHAR2(4) NOT NULL Notification Plan
    ERLY=Early Admission Decision
    REG=Regular Admission Decision
    ROLL=Rolling Admission

    Default Value: REG

    16 REGION Character(10) VARCHAR2(10) NOT NULL Region

    Prompt Table: REGION_TBL

    17 RECRUITER_ID Character(11) VARCHAR2(11) NOT NULL Recruiter ID

    Prompt Table: RECRUITERS

    18 LAST_SCH_ATTEND Character(11) VARCHAR2(11) NOT NULL Last School Attended

    Prompt Table: EXT_ORG_TBL

    19 ADM_APPL_COMPLETE Character(1) VARCHAR2(1) NOT NULL Application Complete

    Y/N Table Edit

    Default Value: N

    20 GRADUATION_DT Date(10) DATE Graduation Date
    21 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    22 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    23 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
    AC=Active in Program
    AD=Admitted
    AP=Applicant
    CM=Completed Program
    CN=Cancelled
    DC=Discontinued
    DE=Deceased
    DM=Dismissed
    LA=Leave of Absence
    PM=Prematriculant
    SP=Suspended
    WT=Waitlisted
    24 PROG_ACTION Character(4) VARCHAR2(4) NOT NULL Program Action
    ACTV=Activate
    ADMT=Admit
    ADRV=Admission Revocation
    APPL=Application
    COMP=Completion of Program
    COND=Conditional Admit
    DATA=Data Change
    DDEF=Defer Decision
    DEFR=Defer Enrollment
    DEIN=Intention to Matriculate
    DENY=Deny
    DISC=Discontinuation
    DISM=Dismissal
    LEAV=Leave of Absence
    MATR=Matriculation
    PLNC=Plan Change
    PRGC=Program Change
    RADM=Readmit
    RAPP=Readmit Application
    RECN=Reconsideration
    REVK=Revoke Degree
    RLOA=Return from Leave of Absence
    SPND=Suspension
    TRAN=Transfer to Other Career
    VDIS=Voluntarily Discontinued
    WADM=Administrative Withdrawal
    WAIT=Waitlist
    WAOF=Waitlist Offer
    WAPP=Applicant Withdrawal
    25 ACTION_DT Date(10) DATE Action Date
    26 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason
    27 ADMIT_TERM Character(4) VARCHAR2(4) NOT NULL Admit Term
    28 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    29 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    30 CITIZENSHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Citizenship Status

    Prompt Table: CITIZEN_STS_TBL

    31 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    32 COMM_DIRECTION Character(4) VARCHAR2(4) NOT NULL Communication Direction
    IN=Incoming Communication
    OUT=Outgoing Communication
    PERS=In Person
    33 UNSUCCESSFUL Character(1) VARCHAR2(1) NOT NULL Unsuccessful Outcome
    34 OUTCOME_REASON Character(1) VARCHAR2(1) NOT NULL Outcome Reason
    C=Missing Critical Data
    E=Invalid Email Address
    M=Left Message on Machine
    N=No Answer
    O=No Org Recipients found
    P=Left Message with Person
    R=Returned Mail
    S=Email Send Error
    35 SCC_LETTER_CD Character(3) VARCHAR2(3) NOT NULL Letter Code
    36 LETTER_PRINTED_DT Date(10) DATE Date letter was printed
    37 LETTER_PRINTED_TM Time(15) TIMESTAMP Time Letter Printed
    38 CHECKLIST_SEQ Number(6,0) INTEGER NOT NULL Checklist Sequence
    39 COMM_COMPLETES Character(1) VARCHAR2(1) NOT NULL Completed By Communication
    40 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    41 STRM Character(4) VARCHAR2(4) NOT NULL Term
    42 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    43 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    44 GROUP_ID_SF Character(15) VARCHAR2(15) NOT NULL Group ID
    45 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    46 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
    47 PAYMENT_ID_NBR Number(12,0) DECIMAL(12) NOT NULL Payment ID Nbr
    48 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    49 CHECKLIST_DTTM_VAR DateTime(26) TIMESTAMP Checklist Date Time
    50 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    51 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    52 RESTRICTED_AID_ID Character(10) VARCHAR2(10) NOT NULL Restricted Aid ID
    53 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
    54 CAMPUS_EVENT_NBR Character(9) VARCHAR2(9) NOT NULL Event ID
    55 EVENT_MTG_NBR Number(4,0) SMALLINT NOT NULL Event Meeting Nbr
    56 EFFDT_VAR Date(10) DATE Effective Date
    57 EFFSEQ_VAR Number(1,0) SMALLINT NOT NULL Effective Date Sequence #
    58 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
    59 COMMENT_PRINT_FLAG Character(1) VARCHAR2(1) NOT NULL Print Comments for Communications
    60 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    61 COLLECTION_ID Number(12,0) DECIMAL(12) NOT NULL Collection ID
    62 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
    63 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
    64 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
    65 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    66 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
    67 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    68 SESSION_NO Character(11) VARCHAR2(11) NOT NULL Session Nbr
    69 GIFT_NO Character(11) VARCHAR2(11) NOT NULL Gift Nbr
    70 RECOGNITION_TYPE Character(1) VARCHAR2(1) NOT NULL Recognition Type
    71 DESIGNATION Character(11) VARCHAR2(11) NOT NULL Designation
    72 INTV_CD Character(10) VARCHAR2(10) NOT NULL Initiative Code
    73 AV_AUDIENCE Character(10) VARCHAR2(10) NOT NULL Audience Code
    74 AUD_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates whether the population is being identified for Segmentation, Reporting, or Administration.
    A=Administrative
    R=Reporting
    S=Segmentation
    75 MEMBERSHIP_NBR Character(12) VARCHAR2(12) NOT NULL Membership Number
    76 AV_MBR_ORG_COD Character(10) VARCHAR2(10) NOT NULL Member Organization Code
    77 AV_STD_BEN Character(6) VARCHAR2(6) NOT NULL Standard Benefit
    78 MBR_PMT_NO Character(11) VARCHAR2(11) NOT NULL Member Payment Number
    79 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center
    80 RECRUITING_STATUS Character(4) VARCHAR2(4) NOT NULL Recruiting Status
    APPL=Applicant
    INAC=Inactive
    INQR=Inquiry
    PAPL=Pre-Applicant
    PROS=Prospect
    SUSP=Suspect
    81 RECR_STATUS_DT Date(10) DATE Recruiting Status Date
    82 APPL_ON_FILE Character(1) VARCHAR2(1) NOT NULL Application on file
    N=No
    Y=Yes
    83 ADM_REFRL_SRCE Character(4) VARCHAR2(4) NOT NULL Referral Source
    84 REFERRAL_SOURCE Character(2) VARCHAR2(2) NOT NULL Referral Source
    AD=Advertisement
    AG=Agency
    CL=Client Referral
    CO=College Recruiting
    CR=College Recommendation
    EE=Employee
    ES=Employment Securitry Bureau
    FE=Former Employee
    JF=Job Fair
    JP=Job Posting
    OH=Open House
    OT=Other Source
    PI=Phone Inquiry
    UK=Unknown
    US=Unsolicited
    WI=Walk-In
    XR=Executive Referral
    XS=Executive Search
    85 ADM_CREATION_DT Date(10) DATE Admission Data Creation Date
    86 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category
    87 COMM_CONTEXT Character(6) VARCHAR2(6) NOT NULL Communication Context
    88 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL Communication Method
    B=Publication
    D=Document
    E=Email
    F=Fax
    L=Letter
    P=Personal Contact
    T=Telephone Call
    W=Web
    89 COMM_BEGIN_TM Time(15) TIMESTAMP Communication Begin Time
    90 COMM_END_TM Time(15) TIMESTAMP Communication End Time
    91 CHECKLIST_CD Character(6) VARCHAR2(6) NOT NULL Checklist Code
    92 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
    93 REFERRAL_SRCE_DT Date(10) DATE Referral Source Date
    94 COMM_COMMENTS Long Character(2000) VARCHAR2(2000) Communication Comments