Data Dictionary - Category
Table Name CLS_CATEGORY_MASTER
Table Comment This table contains Category details Category component enables user to classify various masters and transactions into different groups for better control. Assumptions: · The Category component would be deployed at the LO level. · Inter OU interaction of &nbspCategory would take place.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CAT_CATEGORY	varchar(255)	NOT NULL	Category The various Category defined for a OU Eg : Transport Mode	Yes	No
CAT_CATEGORY_TYPE	varchar(5)	NOT NULL	Unique Category type which is defined under the category Eg : For Transport Type Category, different category could be 1) AIR 2) RAIL 3) SHIP 4) ROAD	Yes	No
CAT_OU	INT	NOT NULL	Organisation Unit, where the Category details is defined.	Yes	No
CAT_LO	varchar(20)	NOT NULL	LO Information where the category created Logistics Level Retirved from EMOD based on OU and stored here Category information maintained at LO level	No	No
CAT_TYPE_DESC	varchar(255)	NOT NULL	Description of the Category Type	No	No
CAT_TYPE_DESC_SHD	varchar(255)	NULL	Shadow column for the category desc	No	No
CAT_STATUS	varchar(8)	NULL	It holds current status of the categorytype The Category Type Status can be any one of the following, 1. Active 2. Inactive 3. Cancelled ---------------------------------- Meta Data Values ---------------------------------- Active              &nbspAC Inactive           &nbspIA Cancelled        &nbspCA ----------------------------------	No	No
CAT_PREV_STATUS	varchar(8)	NULL	The previous status value will be stored in this column.	No	No
CAT_DFLT_FLAG	varchar(8)	NOT NULL	The default value , possible values may be yes or no.	No	No
CAT_CREATED_BY	varchar(30)	NULL	Login User , one who created the Record	No	No
CAT_CREATED_DATE	datetime	NOT NULL	The Date when the record had been created	No	No
CAT_MODIFIED_BY	varchar(30)	NULL	Login User , who recently made the transaction on the record	No	No
CAT_MODIFIED_DATE	datetime	NULL	The Last Date of Modification of the record	No	No
CAT_TIMESTAMP_VALUE	INT	NOT NULL	Timestamp value Will be updated by each transaction	No	No
CAT_ADDL1	INT	NULL	The additional column may be used for future reference with integer datatype.	No	No
CAT_ADDL2	varchar(255)	NULL	The additional column may be used for future reference with char datatype.	No	No
CAT_ADDL3	varchar(255)	NULL	The additional column may be used for future reference with &nbspchar datatype.	No	No