SCC_ORGDMCD_VW

(SQL View)
 Index Back

Org Dpt Recipient MCD

CommGen Org Department Recipient Missing Critical Data view.

SELECT DISTINCT COMMON_ID , SEQ_3C , ORG_DEPARTMENT FROM %Table(SCC_ORGDPTR_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_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr