SSR_ORG_ACDFLT

(SQL Table)
Index Back

  • Parent record: ACAD_ORG_TBL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 SSR_AC_ATND_XDFLT Character(1) VARCHAR2(1) NOT NULL Disable Attendance Default

    Y/N Table Edit

    Default Value: N

    4 SSR_AC_CONT_XDFLT Character(1) VARCHAR2(1) NOT NULL Disable Content Optns Default

    Y/N Table Edit

    Default Value: N

    5 SSR_AC_ID_XDFLT Character(1) VARCHAR2(1) NOT NULL Disable Forms of ID Defaults

    Y/N Table Edit

    Default Value: N

    6 SSR_AC_SCALE_XDFLT Character(1) VARCHAR2(1) NOT NULL Disable Result Scale Defaults

    Y/N Table Edit

    Default Value: N

    7 SSR_AC_ATND_OPT Character(1) VARCHAR2(1) NOT NULL Attendance Tracking Options
    M=Number of Allowed Absences
    N=Number of Classes Attended
    P=Percentage of Classes Attended
    8 SSR_AC_ATND_NBR Number(3,0) SMALLINT NOT NULL Required Attendance Days
    9 SSR_RES_MAP_ID Character(12) VARCHAR2(12) NOT NULL Result Scale

    Prompt Table: SSR_RES_MAP_TBL

    10 SSR_PASSING_MARK Number(8,3) DECIMAL(7,3) NOT NULL Passing Mark
    11 SSR_AC_PASSING_GRD Character(3) VARCHAR2(3) NOT NULL Passing Grade

    Prompt Table: SSR_RES_MAP_VW2

    12 SSR_SHOW_STU_SS Character(1) VARCHAR2(1) NOT NULL Show in Student SS

    Y/N Table Edit

    13 SSR_BLIND_GRADED Character(1) VARCHAR2(1) NOT NULL This field indicates if blind grading is active
    N=Do not Use
    Y=Override Display Values

    Y/N Table Edit

    14 SSR_CALC_STNDRD_CR Character(1) VARCHAR2(1) NOT NULL Calculate Standardized Units

    Y/N Table Edit

    15 SSR_STANDARD_UNITS Number(6,2) DECIMAL(5,2) NOT NULL Standardized Units
    16 SSR_AC_SVCIMP_OVRD Character(1) VARCHAR2(1) NOT NULL Override Service Impact

    Y/N Table Edit

    Default Value: N

    17 SERVICE_IMPACT Character(5) VARCHAR2(5) NOT NULL Service Impact

    Prompt Table: SRVC_IMPACT_VW

    18 SSR_MRK_DISTRIB_ID Character(11) VARCHAR2(11) NOT NULL Mark Distribution Curve
    19 SSR_AC_GRD_RULE_ID Character(10) VARCHAR2(10) NOT NULL Grading Rule ID
    20 SSR_CALC_MARK_RANK Character(1) VARCHAR2(1) NOT NULL Calculate Mark Rank

    Y/N Table Edit

    21 SSR_MANDATORY_PASS Character(1) VARCHAR2(1) NOT NULL Mandatory Pass Required

    Y/N Table Edit

    22 SSR_CW_REQ_INST Character(1) VARCHAR2(1) NOT NULL Required by Institution

    Y/N Table Edit

    23 SSR_CALC_MARK_AVG Character(1) VARCHAR2(1) NOT NULL Calculate Mark Average

    Y/N Table Edit

    24 ASSESSED Character(1) VARCHAR2(1) NOT NULL Assessed

    Y/N Table Edit

    Default Value: Y

    25 SSR_AC_WKLD_H Number(3,0) SMALLINT NOT NULL Workload (hours)
    26 SSR_AC_WKLD_M Number(2,0) SMALLINT NOT NULL Workload Minutes
    27 SSR_ACM_IND_CONT Character(1) VARCHAR2(1) NOT NULL Individualized Content

    Y/N Table Edit

    Default Value: N

    28 SCC_RULE_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine
    29 SSR_AC_CALC_OPT Character(1) VARCHAR2(1) NOT NULL Use Result Scale Minimum Mark

    Y/N Table Edit

    Default Value: N

    30 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    31 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    32 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    33 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time
    34 SSR_ANID_ARR_DEF Character(4) VARCHAR2(4) NOT NULL Activity Result Roster default ID display
    ANON=Anonymous ID only
    BOTH=Anonymous, Student ID and Name
    STUD=Student ID and Name only
    35 SSR_ANID_WKC_DEF Character(4) VARCHAR2(4) NOT NULL Work Center default ID display
    ANON=Anonymous ID
    STID=Do not Display in Workcenter
    36 SSR_ANID_IAM_DEF Character(4) VARCHAR2(4) NOT NULL Individual Activity Manager default ID display
    ANON=Anonymous ID
    BOTH=Anonymous, Student ID and Name
    STUD=Student ID and Name only
    37 OVERRIDE Character(1) VARCHAR2(1) NOT NULL Copy Method