SSR_REQ_LN_NLD

(SQL Table)
 Index Back

Requisition lines

Requisition lines

  • Parent record: SSR_REQUIS_NLD

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_REQ_ID_NLD Character(8) VARCHAR2(8) NOT NULL Requisite ID
    2 EFFDT Date(10) DATE Effective Date
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 SSR_ITEM_ID_NLD Character(8) VARCHAR2(8) NOT NULL Item ID

    Prompt Table: %EDITTABLE

    6 SSR_ITEM_TYPE_NLD Character(1) VARCHAR2(1) NOT NULL Item type for use in Requisites
    C=Calculated Result
    L=Test List
    O=Course
    R=Requisite
    T=Test
    U=Course List
    7 CRITERIA_NOT Character(1) VARCHAR2(1) NOT NULL PeopleSoft Query Not Criteria

    Y/N Table Edit

    8 SSR_BOOL_OPER_NLD Character(1) VARCHAR2(1) NOT NULL Boolean Operators
    A=AND
    D=AND NOT
    O=OR
    R=OR NOT
    9 SSR_PARENTHLFT_NLD Character(1) VARCHAR2(1) NOT NULL Left Parenthesis
    1=(
    2=((
    3=(((
    10 SSR_COMP_OPER_NLD Character(2) VARCHAR2(2) NOT NULL Operators
    <=<
    <==<=
    ===
    >=>
    >==>=
    11 SSR_VALUE_NLD Number(5,2) DECIMAL(4,2) NOT NULL Value
    12 SSR_FUNCTION_NLD Character(1) VARCHAR2(1) NOT NULL Function
    A=Average
    L=In List
    S=Sum Units1
    U=Sum Units2
    13 SSR_MIN_VALUE_NLD Number(7,2) DECIMAL(6,2) NOT NULL Minimum Value
    14 SSR_MAX_VALUE_NLD Number(7,2) DECIMAL(6,2) NOT NULL Maximum Value
    15 SSR_RESTR_USE_NLD Character(1) VARCHAR2(1) NOT NULL Restrict Use
    A=All Result
    R=Restricted
    16 SSR_PARENTHRGT_NLD Character(1) VARCHAR2(1) NOT NULL Parenthesis Right
    1=)
    2=))
    3=)))
    17 SSR_ITEM_DT_NLD Date(10) DATE Item Date
    18 SSR_SHOW_DTL_NLD Character(1) VARCHAR2(1) NOT NULL Show Tests in Evaluation

    Y/N Table Edit

    Default Value: Y