Attribute Name Data Type Maximum Length Optional <ENTITY NAME (without Word)> Number Number(10) should No KEY (preferred) be used with a surrogate key e.g. Or Or LAND USE CODE primary key attribute is Varchar2 Varchar2 LAND USE KEY CREATE USER NAME Varchar2 30 No CREATE TS Date No SHORT NAME Varchar2 If primary key is No Number LONG NAME Varchar2 No DESCRIPTION Varchar2 No BEGIN DATE Date No END DATE Date Yes MODIFY USER NAME Varchar2 30 Yes MODIFY TS Date Yes Table 2 Code Entity Attributes – SHORT NAME If a surrogate key is used, this attribute stores a shortened version of the full name of the code value for use in drop-down fields. LONG NAME Used to hold the fully expanded term of the code value. DESCRIPTION Used to hold the full business description of each code value. Table 3 Code Entity Attribute Definitions – Processing Entity Attributes TEMP and RPT – The following attributes must be included in TEMP and RPT processing entities. Attribute Name Data Type Maximum Length Optional <ENTITY> KEY Number Number(10) should No be used with a e.g. surrogate key PAYMENT TRACKING RPT primary key attribute is PAYMENT TRACKING RPT KEY TEMP PIVOT TABLE DATA primary key attribute is TEMP PIVOT TABLE DATA KEY
Attribute Name Data Type Maximum Length Optional <ENTITY NAME (without Word)> KEY e.g. LAND USE CODE primary key attribute is LAND USE KEY Number (preferred) Or Varchar2 Number(10) should be used with a surrogate key Or Varchar2 No CREATE USER NAME Varchar2 30 No CREATE TS Date No SHORT NAME Varchar2 If primary key is Number No LONG NAME Varchar2 No DESCRIPTION Varchar2 No BEGIN DATE Date No END DATE Date Yes MODIFY USER NAME Varchar2 30 Yes MODIFY TS Date Yes Table 2 – Code Entity Attributes SHORT NAME If a surrogate key is used, this attribute stores a shortened version of the full name of the code value for use in drop-down fields. LONG NAME Used to hold the fully expanded term of the code value. DESCRIPTION Used to hold the full business description of each code value. Table 3 – Code Entity Attribute Definitions Processing Entity Attributes – TEMP and RPT The following attributes must be included in TEMP and RPT processing entities. Attribute Name Data Type Maximum Length Optional <ENTITY> KEY e.g. PAYMENT TRACKING RPT primary key attribute is PAYMENT TRACKING RPT KEY TEMP PIVOT TABLE DATA primary key attribute is TEMP PIVOT TABLE DATA KEY Number Number(10) should be used with a surrogate key No
STD-07092501.4.0_0.docx