SSR_AIR_ELEM_V3

(SQL View)
 Index Back

AIR Elem + Enrl Cat


SELECT a.INSTITUTION , a.SSR_ITEM_ID , a.EFFDT , a.SSR_ITEM_SEQ , a.SSR_CHILD_ITEM_ID , a.SSR_ITEM_WEIGHT , a.SSR_MAX_ATTMPT , a.SSR_ENRL_CAT , a.DEGREE , a.RQ_CONNECT , a.SSR_LPAREN_CNT , a.SSR_RPAREN_CNT , a.SSR_ELEM_LVL_AT , a.SSR_ELEM_LVL_PM , a.SSR_IN_OPTGRP , b.SSR_AUTOMOVE_APT , b.SSR_ALLOW_APT , b.SSR_AUTO_PROCESS , b.SSR_ALLOW_CART , b.SSR_ALLOW_DROP , b.SSR_ALLOW_EDIT , b.SSR_ALLOW_SWAP FROM PS_SSR_AIR_ELEM a LEFT OUTER JOIN PS_SSR_ENRL_CAT b ON a.INSTITUTION=b.INSTITUTION AND a.SSR_ENRL_CAT=b.SSR_ENRL_CAT

  • Parent record: SSR_AIR_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    2 SSR_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Academic Item ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SSR_ITEM_SEQ Number(6,0) INTEGER NOT NULL Sequence Number
    5 SSR_CHILD_ITEM_ID Character(11) VARCHAR2(11) NOT NULL Child Item ID

    Prompt Table: %EDITTABLE3

    6 SSR_ITEM_WEIGHT Number(3,0) SMALLINT NOT NULL Item Weight
    7 SSR_MAX_ATTMPT Number(3,0) SMALLINT NOT NULL Number of Attempts Allowed

    Default Value: 1

    8 SSR_ENRL_CAT Character(4) VARCHAR2(4) NOT NULL Enrollment Category

    Prompt Table: SSR_ENRL_CAT

    9 DEGREE Character(8) VARCHAR2(8) NOT NULL Degree

    Prompt Table: DEGREE_INTRN_VW

    10 RQ_CONNECT Character(4) VARCHAR2(4) NOT NULL Detail Connector
    AND=And
    OR=Or
    11 SSR_LPAREN_CNT Number(1,0) SMALLINT NOT NULL Parenthesis
    12 SSR_RPAREN_CNT Number(1,0) SMALLINT NOT NULL Parenthesis
    13 SSR_ELEM_LVL_AT Character(2) VARCHAR2(2) NOT NULL Element-level Attribute
    00=Use default item attributes
    20=Add to default attributes
    40=Override default attributes

    Default Value: 00

    14 SSR_ELEM_LVL_PM Character(2) VARCHAR2(2) NOT NULL Element-level Parameters
    00=Use default item parameters
    20=Add to default parameters
    40=Override default parameters

    Default Value: 00

    15 SSR_IN_OPTGRP Character(1) VARCHAR2(1) NOT NULL Part of an option group

    Y/N Table Edit

    Default Value: N

    16 SSR_AUTOMOVE_APT Character(1) VARCHAR2(1) NOT NULL Automatically move to APT

    Y/N Table Edit

    Default Value: N

    17 SSR_ALLOW_APT Character(1) VARCHAR2(1) NOT NULL Allow Add/Remove from APT

    Y/N Table Edit

    Default Value: N

    18 SSR_AUTO_PROCESS Character(1) VARCHAR2(1) NOT NULL If Y, will be picked up by the PE Block Enrollment process.

    Y/N Table Edit

    Default Value: N

    19 SSR_ALLOW_CART Character(1) VARCHAR2(1) NOT NULL Allow Add/Remove from Cart

    Y/N Table Edit

    Default Value: N

    20 SSR_ALLOW_DROP Character(1) VARCHAR2(1) NOT NULL Allow Class Drop

    Y/N Table Edit

    Default Value: N

    21 SSR_ALLOW_EDIT Character(1) VARCHAR2(1) NOT NULL Allow Class Edit

    Y/N Table Edit

    Default Value: N

    22 SSR_ALLOW_SWAP Character(1) VARCHAR2(1) NOT NULL Allow Class Swap

    Y/N Table Edit

    Default Value: N