SCC_COMMRMCD_VW

(SQL View)
 Index Back

Comm Recipient MCD View

CommGen Comm Recipient Missing Critical Data view

SELECT DISTINCT COMMON_ID , SEQ_3C , RELATIONSHIP_NBR FROM %Table(SCC_COMMR_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 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr