SCC_ORGCMCD_VW

(SQL View)
 Index Back

Org Contact Recipient MCD View

CommGen Org Contact Recipient Missing Critical Data View.

SELECT DISTINCT COMMON_ID , SEQ_3C , ORG_CONTACT FROM %Table(SCC_ORGCTCR_MCD)

  • Parent record: COMMUNICATION

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
    2 SEQ_3C Number(5,0) INTEGER NOT NULL Sequence Number
    3 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr

    Prompt Table: ORG_CONTACT