MAKE_ANL_DB_REQ

index back

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
RUN_CNTL_IDCharacter(30)VARCHAR2(30) NOT NULLRun Control ID
ANALYSIS_DB_IDCharacter(15)VARCHAR2(15) NOT NULLCube Instance ID

Prompt Table: ANALYSIS_DB

ANL_DB_MD_ACTIONCharacter(1)VARCHAR2(1) NOT NULLStructure Action
C=Create
N=None
U=Update

Default: C

ANL_DB_DATA_ACTIONCharacter(1)VARCHAR2(1) NOT NULLData Action
L=Update Data
N=None
R=Create Data

Default: L

ANL_DB_AGG_ACTIONCharacter(1)VARCHAR2(1) NOT NULLAggregate Action
C=Create
N=None
U=Update

Default: C

BUSINESS_UNITCharacter(5)VARCHAR2(5) NOT NULLBusiness Unit
AS_OF_DATEDate(10)DATEAs of Date

Default: %date

CUBE_BOOK_MARKCharacter(20)VARCHAR2(20) NOT NULLCube Book Mark
POST_BUILD_SCRIPTCharacter(254)VARCHAR2(254) NOT NULLPost-Build Script
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19