POS_SOURCE_TBL

(SQL Table)
 Index Back

Positions Data Source Table

Position Data Sources table. used as part of the Position Definitions. Defines the sources of data in a user friendly naming convention

  • Related Language Record: POS_SOURCE_LNG

  • Parent Record Of POS_SOURCE_CNTC POS_SOURCE_KEYS POS_SOURCE_SEL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

    Prompt Table: POS_SOURCE_SRCH

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    5 POS_IS_DEAL_SRC Character(1) VARCHAR2(1) NOT NULL Filed used to determine if a Position source is over a deal table

    Y/N Table Edit

    Default Value: N

    6 INTEGRATION_MAP_ID Character(10) VARCHAR2(10) NOT NULL Unique Identifier for an integration map.

    Prompt Table: TR_INT_MAP_HDR

    7 REV_AMOUNT_SIGN Character(1) VARCHAR2(1) NOT NULL Position source indicator that specifies that the amount sign is to be reveresed.

    Y/N Table Edit

    Default Value: N

    8 NON_CASH_SOURCE Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not (Y or N) a position source is a non-cash flow source.

    Y/N Table Edit

    Default Value: N

    9 INTERCOMPANY_FLG Character(1) VARCHAR2(1) NOT NULL /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/

    Y/N Table Edit

    Default Value: N

    10 PMT_DRILL_TO_SRC Character(1) VARCHAR2(1) NOT NULL Drill to Source Transaction
    C=Component
    D=DoModal Component
    E=External URL
    N=None

    Default Value: N

    11 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

    Prompt Table: MENU_PNLGRP_VW

    13 SOURCE_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: RECDEFN_VW

    14 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL_ADDRESS