SSR_ACE_DT_CTRL

(SQL Table)
 Index Back

  • Parent record: SSR_ACE_DT_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 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

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

    Prompt Table: TERM_TBL

    5 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    6 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

    Prompt Table: SSR_AC_ITEMTYPE

    7 SSR_ACE_TRANS_TYPE Character(2) VARCHAR2(2) NOT NULL Transaction Type
    A=All
    D=Drop
    E=Enroll
    S=Swap

    Default Value: A

    8 SSR_ACE_DATE_ID Character(12) VARCHAR2(12) NOT NULL Activity Action ID
    9 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    10 SSR_ACE_START_OPT Character(2) VARCHAR2(2) NOT NULL Activity Action Start Date
    AH=Ad Hoc Date
    AI=Assessment Item Start Date
    AO=Academic Period Open Enroll
    AP=Academic Period Start Date
    FE=First Date to Enroll
    SB=Session Begin Date
    TB=Term Begin Date

    Default Value: FE

    11 SSR_ACE_START_CALC Character(1) VARCHAR2(1) NOT NULL Calculate Start Date

    Y/N Table Edit

    Default Value: Y

    12 SSR_ACE_START_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust Start Date
    13 SSR_ACE_START_DATE Date(10) DATE Start Date
    14 SSR_ACE_START_TIME Time(15) TIMESTAMP Start Time
    15 SSR_ACE_END_OPT Character(2) VARCHAR2(2) NOT NULL Activity Action End Date
    AD=Assessment Item Due Date
    AH=Ad Hoc Date
    AI=Assessment Item Start Date
    AO=Academic Period Open Enrl End
    AP=Academic Period End Date
    LE=Last Date to Enroll
    SE=Session End Date
    TE=Term End Date

    Default Value: LE

    16 SSR_ACE_END_CALC Character(1) VARCHAR2(1) NOT NULL Calculate End Date

    Y/N Table Edit

    Default Value: Y

    17 SSR_ACE_END_ADJ Signed Number(4,0) DECIMAL(3) NOT NULL Adjust End Date
    18 SSR_ACE_END_DATE Date(10) DATE End Date
    19 SSR_ACE_END_TIME Time(15) TIMESTAMP End Time
    20 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    21 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    22 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    23 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time