AUC_H_CLBGP_VW2

(SQL View)
 Index Back

Sourcing Event Collaborators


SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , B.AUC_COLLAB_GRP_NBR , B.AUC_COLLAB_GRP , B.WEIGHTING FROM PS_AUC_HDR_COLLAB A , PS_AUC_HDR_CLB_GRP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.AUC_COLLAB_SRC IN ('A','B')

  • Parent record: AUC_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID
    3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round
    4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
    5 AUC_COLLAB_GRP_NBR Number(3,0) SMALLINT NOT NULL Collaboration Group Number
    6 AUC_COLLAB_GRP Character(40) VARCHAR2(40) NOT NULL Collaboration Group
    7 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals