CAN_RPT_SES_TBL

(SQL Table)
 Index Back

SESHUN Prompt Table

SACE98-D NEW: SR40 Cdn Reporting Requirements - SESHUN Prompt Table

  • Related Language Record: CAN_RPT_SES_LAN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CAN_RPT_SESHUN Character(2) VARCHAR2(2) NOT NULL Seshun Value
    11=Academic Year
    21=Semester 1
    22=Semester 2
    31=Trimester 1
    32=Trimester 2
    33=Trimester 3
    41=Calendar Year
    68=Summer School (Intersession)
    78=Summer School
    81=Other
    82=Other
    83=Other
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: CAN_RPT_SES_TBL.DESCR

    6 CAN_RPT_REG_PERIOD Character(1) VARCHAR2(1) NOT NULL Registration Period