MAKE_ANL_DB_REQ

index back

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

Prompt Table: ANALYSIS_DB

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

Default: C

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

Default: L

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

Default: C

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

Default: %date

CUBE_BOOK_MARK Character(20) VARCHAR2(20) NOT NULL Cube Book Mark
POST_BUILD_SCRIPT Character(254) VARCHAR2(254) NOT NULL Post-Build Script
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19