CP_RULECPY_VW

(SQL View)
 Index Back

CP Rule Number Copy View

View of CP_RULE_HDR for Prompt

SELECT SETID , CP_AREA , ACTION_INTL_CD , RULE_NUMBER , RULE_DESCRIPTION , RULE_SRCH_1 , RULE_SRCH_2 , RULE_SRCH_3 , RULE_SRCH_4 , RULE_SRCH_5 , RULE_ACTIVE_FLAG , DATE_IN_EFFECT , DATE_OBSOLETE FROM PS_CP_RULE_HDR

  • Parent record: CP_RULE_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Prompt Table: SP_SETID_NONVW

    2 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
    0=Distribution
    1=Production
    3 ACTION_INTL_CD Character(2) VARCHAR2(2) NOT NULL CP Action International Code Field
    01=Condition
    02=Secondary Variable
    03=Global Variable
    04=Option Variable
    05=Internal Variable Override
    06=Create External Parameter
    07=Configuration Detail
    08=Start Trace
    09=End Trace
    20=Page Generation
    21=Page Validation
    22=Configured Component
    23=Purchase Item
    24=Finalized Price
    25=Finalized Cost
    26=Finalized Date
    27=Availability Date
    28=Workflow
    29=Kit Component
    30=Component List
    31=Operation Sequence
    32=Generate Comment
    33=Product Selector
    34=Kit Generation
    35=Finalized Weight
    36=Finalized Volume
    4 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
    5 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Field used for storing Rule Description
    6 RULE_SRCH_1 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 1
    7 RULE_SRCH_2 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 2
    8 RULE_SRCH_3 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 3
    9 RULE_SRCH_4 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 4
    10 RULE_SRCH_5 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 5
    11 RULE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    12 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label
    13 DATE_OBSOLETE Date(10) DATE Obsolete Date