AUC_AWD_CBR_VW

(SQL View)
 Index Back

Sourcing Event Collaborators


SELECT DISTINCT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , D.AUC_COLLAB_OPRID , D.AUC_COLLAB_GRP_NBR , D.AUC_ROUTE_SEQ , D.AUC_COLLAB_SRC , D.AUC_AWD_CLB_STATUS , D.NOTIFIED_FLAG , D.DELETE_FLAG , D.REVIEWED , E.OPRDEFNDESC FROM PS_AUC_HDR_CLB_GRP A , PS_AUC_LN_BID_FCTR B , PS_AUC_LN_BF_RVW C , PS_AUC_HDR_COLLAB D , PSOPRDEFN E 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.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 B.BID_FACTOR_NBR = C.BID_FACTOR_NBR AND B.LINE_NBR = C.LINE_NBR AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.AUC_ID = D.AUC_ID AND A.AUC_ROUND = D.AUC_ROUND AND A.AUC_VERSION = D.AUC_VERSION AND A.AUC_COLLAB_GRP_NBR = D.AUC_COLLAB_GRP_NBR AND D.AUC_COLLAB_OPRID = E.OPRID 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_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