POS_CREATE_WHR2

(SQL View)
Index Back

Position Deal Where 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 Deal Conditions 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.FIELDCHANGE

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 = '02' 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