MAKE_ANL_DB_REQ

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 ANALYSIS_DB_ID Character(15) VARCHAR2(15) NOT NULL Cube Instance ID

Prompt Table: ANALYSIS_DB

4 ANL_DB_MD_ACTION Character(1) VARCHAR2(1) NOT NULL Structure Action
C=Create
N=None
U=Update

Default Value: C

5 ANL_DB_DATA_ACTION Character(1) VARCHAR2(1) NOT NULL Data Action
L=Update Data
N=None
R=Create Data

Default Value: L

6 ANL_DB_AGG_ACTION Character(1) VARCHAR2(1) NOT NULL Aggregate Action
C=Create
N=None
U=Update

Default Value: C

7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 AS_OF_DATE Date(10) DATE As of Date

Default Value: %date

9 CUBE_BOOK_MARK Character(20) VARCHAR2(20) NOT NULL Cube Book Mark
10 POST_BUILD_SCRIPT Character(254) VARCHAR2(254) NOT NULL Post-Build Script