ANL_DB_QRY_ESS

index back

PeopleSoft Field NameField TypeColumn TypeDescription
ANALYSIS_DB_IDCharacter(15)VARCHAR2(15) NOT NULLCube Instance ID
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name

Prompt Table: QUERY_DIM_VW

RATE_CUBE_TIMECharacter(30)VARCHAR2(30) NOT NULLRate Cube Time Dimension Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_NAMCharacter(30)VARCHAR2(30) NOT NULLRate Country Name Dim Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_CATCharacter(30)VARCHAR2(30) NOT NULLRate Account Dim Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_TYPCharacter(30)VARCHAR2(30) NOT NULLRate Currency Type

Prompt Table: QRY_FLD_HDNG_VW

RATE_CUBE_CURR_AMTCharacter(30)VARCHAR2(30) NOT NULLRate Cube Curr Amount Field

Prompt Table: QRY_FLD_HDNG_VW

RATE_CURR_DEF_NAMECharacter(30)VARCHAR2(30) NOT NULLDefault Currency Name

Default: US$

RATE_CURR_DEF_CATCharacter(30)VARCHAR2(30) NOT NULLDefault Currency Category
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19