POS_CREATE_WHER

(SQL View)
 Index Back

Position Bin 'Where' -Bin View

View used to pull in all the info to create the Row by row SQL for each node. This view is used for the Selection Criteria Creation. 3/23/98 AK - Removed "META_TEXT" because INFORMIX could not handle it. To get the value of META_TEXT a SQLEXEC is done in POSITION_WRK.POS_CREATE_SQL.FILEDCHANGE

SELECT A.SETID , A.TREE_NAME , A.SOURCE_SET ,A.POS_SOURCE_ID , A.TREE_NODE , A.SEQ_NUM , A.ALIAS_NAME , B.FIELDNAME ,B.FIELDTYPE , D.META_FIELD , A.FIELD_VALUE_STR , A.FIELD_VALUE_NBR , A.FIELD_VALUE_DATE , A.RELATIVE_DATE , A.COMP_OPERATOR , A.OPEN_BRCKT , A.CLOSE_BRCKT , A.AND_OR_TXT , A.NODE_SQL ,A.WHERE_TYPE FROM PS_POS_WHERE_TBL A , PS_POS_SOURCE_TBL2 B , PS_POS_FIELD_TYPE D WHERE A.SETID = B.SETID AND A.WHERE_TYPE = '01' AND A.POS_SOURCE_ID = B.POS_SOURCE_ID AND A.ALIAS_NAME = B.ALIAS_NAME AND A.ALIAS_NAME = D.ALIAS_NAME

  • Parent record: POS_HDR_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name
    3 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.
    4 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset
    5 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name
    6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    7 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

    Prompt Table: POS_SOURCE_VW

    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    10 META_FIELD Character(2) VARCHAR2(2) NOT NULL Allows the user to create a specialized data variable that can be utilized in building a position data source.
    11 FIELD_VALUE_STR Character(30) VARCHAR2(30) NOT NULL An accounting template field designated to support the substitution of desired character field values du

    Prompt Table: %EDITTABLE

    12 FIELD_VALUE_NBR Signed Number(28,3) DECIMAL(26,3) NOT NULL An accounting template field designated to support the substitution of desired monetary amounts during a
    13 FIELD_VALUE_DATE Date(10) DATE An accounting template field designated to support the substitution of desired dates during accounting b
    14 RELATIVE_DATE Character(1) VARCHAR2(1) NOT NULL "Represents the number of days
    15 COMP_OPERATOR Character(2) VARCHAR2(2) NOT NULL Represents SQL field comparison syntax when the user is creating node specific data selection criteria
    <=<
    <==<=
    <>=<>
    ===
    >=>
    >==>=
    B=Begins With
    C=Contains
    E=Ends With
    NB=Doesn't Begins With
    NC=Doesn't Contains
    NE=Doesn't Ends With
    16 OPEN_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data
    01=(
    02=((
    03=(((
    04=((((
    17 CLOSE_BRCKT Character(2) VARCHAR2(2) NOT NULL Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat
    01=)
    02=))
    03=)))
    04=))))
    18 AND_OR_TXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
    AND=AND
    OR=OR
    19 NODE_SQL Character(254) VARCHAR2(254) NOT NULL Represents the field in which a user can enter specific SQL criteria in order to select and display position data.
    20 WHERE_TYPE Character(2) VARCHAR2(2) NOT NULL An internal work field that indicates whether user defined position tree SQL criteria is utilized for either p
    01=Bin Impact
    02=Deal Conditions