AR_CMGT_CF_DTLS_GT

Temporary table, contains the credit case folder details for case folder creation/refresh.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
AR_CMGT_CF_DTLS_GT_PK	CASE_FOLDER_DTL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CASE_FOLDER_DTL_ID	NUMBER		18	Yes	Unique identifier for case folder details.
CASE_FOLDER_ID	NUMBER		18	Yes	Unique identifier for case folder.
DATA_POINT_CATEGORY_CODE	VARCHAR2	30			Category of the data point. Values are based on the lookup AR_CMGT_DATA_POINT_CATEGORY.
DATA_POINT_ID	NUMBER		18	Yes	Unique identifier for data point.
DATA_POINT_VALUE_CHAR	VARCHAR2	240			Value for data points of VARCHAR2 type.
DATA_POINT_VALUE_NUM	NUMBER				Value for data points of NUMBER type in case folder currency.
DATA_POINT_VALUE_SCORE_NUM	NUMBER				Value for data points of NUMBER type in scoring model currency.
DATA_POINT_VALUE_DATE	DATE				Value for data points of DATE type.
POINTS_EARNED_SCORE	NUMBER				Earned score for the data point.
WEIGHTED_EARNED_SCORE	NUMBER				Weighted earned score for the data point.
DATA_POINT_SHOW_FLAG	VARCHAR2	1			Indicates if the data point should be displayed.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.

Indexes

Index	Uniqueness	Columns
AR_CMGT_CF_DTLS_GT_U1	Unique	CASE_FOLDER_DTL_ID