SCC_ORGLMCD_VW

(SQL View)
 Index Back

Org Location Recipient MCD

CommGen Org Location Recipient Missing Critical Data view

SELECT DISTINCT COMMON_ID , SEQ_3C , ORG_LOCATION FROM %Table(SCC_ORGLOCR_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_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr