OPR_DEF_TBL_CS

(SQL Table)
 Index Back

Operator Default Table - CS

This table contains operator defaults for Campus Solutions.

  • Parent Record Of OPR_SPDKEY_FUNC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRDEFN2

    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

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

    Default Value: INSTALLATION_SA.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    5 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    7 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    8 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_SCTY

    9 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    10 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan

    Prompt Table: ACAD_SUBPLN_TBL

    11 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Prompt Table: AID_YEAR_TBL

    12 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

    13 SETID_FACILITY Character(5) VARCHAR2(5) NOT NULL Facility Group SetID

    Prompt Table: SETID_TBL

    14 SETID_CAREER Character(5) VARCHAR2(5) NOT NULL Career Group SetID

    Prompt Table: SETID_TBL

    15 ENRL_ACCESS_ID Character(4) VARCHAR2(4) NOT NULL Enrollment Access ID

    Prompt Table: ENRMT_OVRD_TBL

    16 OVRD_CLASS_LIMIT Character(1) VARCHAR2(1) NOT NULL Used by SR Enrollments and Class Permissions.

    Y/N Table Edit

    Default Value: N

    17 OVRD_UNIT_LOAD Character(1) VARCHAR2(1) NOT NULL Override Unit Load

    Y/N Table Edit

    Default Value: N

    18 OVRD_CLASS_PRMSN Character(1) VARCHAR2(1) NOT NULL Override Class Permission

    Y/N Table Edit

    Default Value: N

    19 OVRD_REQUISITES Character(1) VARCHAR2(1) NOT NULL Override Requisites

    Y/N Table Edit

    Default Value: N

    20 OVRD_TIME_CNFLCT Character(1) VARCHAR2(1) NOT NULL Override Time Conflict

    Y/N Table Edit

    Default Value: N

    21 WAIT_LIST_OKAY Character(1) VARCHAR2(1) NOT NULL Wait List Okay

    Y/N Table Edit

    Default Value: N

    22 OVRD_ENRL_ACTN_DT Character(1) VARCHAR2(1) NOT NULL Override Action Date

    Y/N Table Edit

    Default Value: N

    23 CARRY_ID Character(1) VARCHAR2(1) NOT NULL Carry Employee ID

    Y/N Table Edit

    Default Value: N

    24 ADM_RECR_CTR Character(4) VARCHAR2(4) NOT NULL Recruiting Center

    Prompt Table: ADM_RECRCTR_SVW

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

    Prompt Table: ADM_APPLCTR_SVW

    26 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office

    Prompt Table: SP_CSHOFF_NONVW

    27 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

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

    Prompt Table: ADMIT_TYPE_VW

    29 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: CAMPUS_TBL

    30 OUTPUT_DEST Character(1) VARCHAR2(1) NOT NULL Output Destination
    1=Printer
    2=Page
    31 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
    32 ADM_APPL_METHOD Character(3) VARCHAR2(3) NOT NULL Application Method
    DSK=Diskette
    EDI=EDI
    HRD=Hard Copy
    OUA=Ontario University Application
    SRV=Application Service
    WWW=Web Application
    33 TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL Transcript Type

    Prompt Table: SCRTY_TSCRPT_VW

    34 ENRL_ACCESS_GROUP Character(4) VARCHAR2(4) NOT NULL Enrollment Access Group

    Prompt Table: ENRL_ACCESS_GRP

    35 HOUSING_INTEREST Character(1) VARCHAR2(1) NOT NULL Housing Interest
    C=Commuter
    F=Off Campus Housing
    H=On Campus Housing
    36 FIN_AID_INTEREST Character(1) VARCHAR2(1) NOT NULL Financial Aid Interest

    Y/N Table Edit

    Default Value: N

    37 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
    OFF=Official
    UNO=Unofficial
    38 DATA_MEDIUM_RCVD Character(1) VARCHAR2(1) NOT NULL Transcript Rcvd Medium

    Prompt Table: XL_DATA_MEDM_VW

    39 DATA_SOURCE_RCVD Character(3) VARCHAR2(3) NOT NULL This field is used in as an operator default field in the record OPR_DEF_TBL_CS and prompt values are set to the same values as the field DATA_SOURCE and is used in the record EXT_ACAD_DATA for operator default values.

    Prompt Table: XL_DATA_SRCE_VW

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

    Prompt Table: EXT_ORGSCHL_VW

    41 GRADUATION_DT Date(10) DATE Graduation Date
    42 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

    Prompt Table: SP_ISET_NONVW

    43 ISET_OVRD Character(5) VARCHAR2(5) NOT NULL Institution Set

    Prompt Table: SP_ISET_NONVW

    44 SEV_SCHOOL_CD Character(15) VARCHAR2(15) NOT NULL SEVIS School Code

    Prompt Table: SEV_SCHL_CD_TBL

    45 SEV_PRG_NBR Character(9) VARCHAR2(9) NOT NULL SEVIS Program Number

    Prompt Table: SEV_PRG_SP_TBL

    46 PRINTER_NAME Character(127) VARCHAR2(127) NOT NULL Printer Name
    47 SAA_TSCRPT_TYPE Character(5) VARCHAR2(5) NOT NULL This field is used to save a operator default for report type in the Campus Solutions operator default record.

    Prompt Table: SAA_RPT_TYP_TBL

    48 TSCRPT_TYPE2 Character(5) VARCHAR2(5) NOT NULL Flexible Transcript Type

    Prompt Table: SSR_SCRTY_TS_VW