AUC_HDR_COLLAB

(SQL Table)
Index Back

Sourcing Event Collaborators

Sourcing Event Collaborators

  • 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_OPRID Character(30) VARCHAR2(30) NOT NULL Collaborator OPRID

    Prompt Table: AUC_COLLAB_USER

    7 AUC_COLLAB_SRC Character(1) VARCHAR2(1) NOT NULL Collaboration Source
    A=Award
    B=Split Analysis
    C=Event Create

    Default Value: C

    8 AUC_ROUTE_SEQ Number(3,0) SMALLINT NOT NULL Routing Sequence
    9 AUC_AWD_CLB_STATUS Character(1) VARCHAR2(1) NOT NULL Collaboration Award Status
    P=Pending
    R=Reviewed

    Default Value: P

    10 NOTIFIED_FLAG Character(1) VARCHAR2(1) NOT NULL Notified Flag

    Y/N Table Edit

    Default Value: N

    11 NOTIFIED_AWD_FLAG Character(1) VARCHAR2(1) NOT NULL Notified flag for analysis collaboration.

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    14 REVIEWED_AWD Character(1) VARCHAR2(1) NOT NULL Analysis Review Complete

    Y/N Table Edit

    Default Value: N

    15 AUC_REVIEW_BY_DTTM DateTime(26) TIMESTAMP Review By DateTime
    16 AUC_AWDRVW_BY_DTTM DateTime(26) TIMESTAMP Analysis Review By
    17 AUC_DELEGATE_OPRID Character(30) VARCHAR2(30) NOT NULL Delegate Collaborator OPRID

    Prompt Table: AUC_COLLAB_USER

    18 AUC_DEL_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Main Collaborator

    Y/N Table Edit

    Default Value: N

    19 AUC_ROUTE_DTTM DateTime(26) TIMESTAMP Routed To DateTime
    20 AUC_AWD_ROUTE_DTTM DateTime(26) TIMESTAMP Routed To DateTime
    21 AUC_LAST_NTFY_DTTM DateTime(26) TIMESTAMP Last Notified DateTime
    22 AUC_EDIT_RFX_FLG Character(1) VARCHAR2(1) NOT NULL Allow RFx Document Edit

    Default Value: N