AUC_AWD_CLB_VW3

(SQL View)
 Index Back

Sourcing Event Collaborators


SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.AUC_COLLAB_OPRID ,A.AUC_COLLAB_GRP_NBR , A.AUC_ROUTE_SEQ , A.AUC_COLLAB_SRC , A.AUC_AWD_CLB_STATUS , A.NOTIFIED_FLAG , A.DELETE_FLAG , A.REVIEWED , B.OPRDEFNDESC FROM PS_AUC_HDR_COLLAB A , PSOPRDEFN B , PS_AUC_HDR_FCT_RVW C WHERE A.AUC_COLLAB_OPRID = B.OPRID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND A.AUC_COLLAB_GRP_NBR = C.AUC_COLLAB_GRP_NBR AND 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_OPRID Character(30) VARCHAR2(30) NOT NULL Collaborator OPRID

    Prompt Table: AUC_COLLAB_USER

    6 AUC_COLLAB_GRP_NBR Number(3,0) SMALLINT NOT NULL Collaboration Group Number
    7 AUC_ROUTE_SEQ Number(3,0) SMALLINT NOT NULL Routing Sequence
    8 AUC_COLLAB_SRC Character(1) VARCHAR2(1) NOT NULL Collaboration Source
    A=Award
    B=Split Analysis
    C=Event Create

    Default Value: C

    9 AUC_AWD_CLB_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Award Status
    P=Pending
    R=Reviewed
    10 NOTIFIED_FLAG Character(1) VARCHAR2(1) NOT NULL Notified Flag

    Y/N Table Edit

    Default Value: N

    11 DELETE_FLAG Character(1) VARCHAR2(1) NOT NULL Deletion Flag

    Y/N Table Edit

    Default Value: N

    12 REVIEWED Character(1) VARCHAR2(1) NOT NULL Review Complete
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    13 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user