AUC_TASK_REQ

(SQL Table)
Index Back

Task Requirement

Plan Task Requirement

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: AUC_BU_ASSGN_VW

2 AUC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Sourcing Planning ID
3 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version
4 AUC_TASK_NUM Number(3,0) SMALLINT NOT NULL Task number
5 AUC_TASK_REQ_NUM Number(3,0) SMALLINT NOT NULL Task Requirement Number

Default Value: 1

6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

Default Value: 1

7 AUC_REQ_TYPE Character(1) VARCHAR2(1) NOT NULL Task Requirement Type
A=Attachment
C=Comment
E=Sourcing Event
8 AUC_COMPLETE_MTHD Character(2) VARCHAR2(2) NOT NULL Task requirement completion method
EA=Event Approved
EE=Event Ends
EP=Event Posted
ES=Event Starts
EW=Event Awarded
9 AUC_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Task requirement status
C=Complete
N=Not Complete

Default Value: N

10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 DESCR2000 Long Character(2000) VARCHAR2(2000) Description whose maximum length is 2000 characters.
12 AUC_TSK_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Task requirement Business Unit
13 AUC_TSK_EVENT_ID Character(10) VARCHAR2(10) NOT NULL Task requirement event ID