AUC_TMPLTE_DEPT

(SQL Table)
Index Back

Sourcing Template Dept Assign

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

Default Value: AUC_HDR.BUSINESS_UNIT

2 AUC_ID Character(10) VARCHAR2(10) NOT NULL Event ID

Default Value: AUC_HDR.AUC_ID

3 AUC_ROUND Number(5,0) INTEGER NOT NULL Event Round

Default Value: AUC_HDR.AUC_ROUND

4 AUC_VERSION Number(5,0) INTEGER NOT NULL Event Version

Default Value: AUC_HDR.AUC_VERSION

5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL
Set Control Field: BUSINESS_UNIT