TRP_POOL_CNT

(SQL Table)
Index Back

Pool Contacts

Investment Pool contacts

  • Parent record: TRP_POOL_DEFN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BU_GL_NONVW

    2 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.

    Prompt Table: TRP_POOL_DEFN

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: TRP_CONTACT_VW
    Set Control Field: SETID