Data Dictionary -- Smartcard

Srl. No.	Table Name	Comment
1	sci_cardappln_grp_mst	Smart card group master
2	sci_cardappln_mst	Smart card issue
3	sci_cardidgen_dtl	Smart card generation details
4	sci_cardstatus_mst	Smart card status master
5	sci_cardtype_mst	Smart card type master
6	sci_cardusage_log	Smart card usage log
7	sci_functiongrp_mst	Smart card function group master
8	sci_system_param_dtl	Smart card parameter details
9	sci_sys_config_at	Smart card configuration
10	sci_sys_config_dtl	System configuration details
11	sci_usercard_dtl	Smart card details
12	sci_userstatus_mst	User status master details
13	sci_user_enroll_mst	Enrollment master details
14	sci_user_inactivecard_dtl	Inactive card details

Table Name :	sci_cardappln_grp_mst
Comment :	Smart card group master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
card_appln_grp_cd	_varchar_15	varchar(15)	No	Group code	Yes
card_appln_grp_desc	_varchar_50	varchar(50)	Yes	Group description	No

Table Name :	sci_cardappln_mst
Comment :	Smart card issue

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
card_appln_grp_cd	_varchar_15	varchar(15)	Yes	Group description - upper case	No
card_appln_cd	_varchar_15	varchar(15)	No	Smart Card	Yes
card_appln_desc	_varchar_50	varchar(50)	Yes	Smart Card Description	No
card_appln_fileaddr	_varchar_15	varchar(15)	Yes	File address	No

Table Name :	sci_cardidgen_dtl
Comment :	Smart card generation details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cardidgen_prefix	_varchar_20	varchar(20)	No	Generated card prefix	Yes
cardidgen_lastgen_no	_numeric_3_0	numeric(3)	Yes	Last Generated no	No
cardidgen_lastgen_dt	_datetime_8	datetime(8)	Yes	Last Generated date	No

Table Name :	sci_cardstatus_mst
Comment :	Smart card status master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
card_status_cd	_varchar_2	varchar(2)	No	card_status_code	Yes
card_status_desc	_varchar_15	varchar(15)	Yes	card status description	No

Table Name :	sci_cardtype_mst
Comment :	Smart card type master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
card_type	_varchar_15	varchar(15)	No	card type	Yes
card_type_desc	_varchar_30	varchar(30)	Yes	card type description	No

Table Name :	sci_cardusage_log
Comment :	Smart card usage log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
card_user_id	_varchar_20	varchar(20)	Yes	card userid	No
card_uniqueid	_varchar_64	varchar(64)	Yes	card uniqueid	No
card_appln_cd	_varchar_15	varchar(15)	Yes	card_appln_cd	No
screen_cd	_varchar_20	varchar(20)	Yes	screen code	No
screen_ou	_numeric_18_0	Numeric(18)	Yes	screen ouinstance	No
createdby	_varchar_10	varchar(10)	Yes	createdby	No
createddate	_datetime_8	datetime(8)	Yes	createddate	No

Table Name :	sci_functiongrp_mst
Comment :	Smart card function group master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
frgp_card_appln_cd	_varchar_15	varchar(15)	Yes	card signature code	No
fgrp_screen_cd	_varchar_20	varchar(20)	No	Screen code	Yes
fgrp_screen_desc	_varchar_50	varchar(50)	Yes	Screen description	No
fgrp_project_id	_varchar_40	varchar(40)	Yes	Project id	No
fgrp_component	_varchar_40	varchar(40)	Yes	component name	No
fgrp_activityid	udd_documentno	varchar(40)	Yes	activityid	No
fgrp_ilbocode	_varchar_200	varchar(200)	Yes	ilbocode	No
fgrp_task	_varchar_100	varchar(100)	Yes	task name	No

Table Name :	sci_system_param_dtl
Comment :	Smart card parameter details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
scisys_parameter_code	_varchar_20	varchar(20)	No	parameter code	Yes
scisys_parameter_value	_varchar_40	varchar(40)	Yes	parameter value	No
scisys_parameter_text	_varchar_80	varchar(80)	Yes	parameter description	No
scisys_created_by	_varchar_30	varchar(30)	Yes	Parameter createdby	No
scisys_created_date	_datetime_8	datetime(8)	Yes	Parameter createddate	No
scisys_modified_by	_varchar_30	varchar(30)	Yes	modified user	No
scisys_modified_date	_datetime_8	datetime(8)	Yes	modified date	No
scisys_timestamp	_numeric_18_0	Numeric(18)	No	timestamp	No

Table Name :	sci_sys_config_at
Comment :	Smart card configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
config_at_code	_varchar_20	varchar(20)	No	attribute code	Yes
config_at_value	_varchar_40	varchar(40)	Yes	attribute value	No

Table Name :	sci_sys_config_dtl
Comment :	System configuration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
config_ouinstid	_numeric_4_0	numeric(4)	No	ouinstance	Yes
config_component	_varchar_40	varchar(40)	No	component	Yes
config_screen_cd	_varchar_20	varchar(20)	No	screen code	Yes
config_is_enabled	_varchar_1	varchar(1)	Yes	enabled code	No
config_timestamp	_numeric_10_0	numeric(10)	Yes	timestamp	No
config_createdby	_varchar_10	varchar(10)	Yes	createdby	No
config_createddate	_datetime_8	datetime(8)	Yes	createddate	No
config_modifiedby	_varchar_10	varchar(10)	Yes	modifiedby	No
config_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	sci_usercard_dtl
Comment :	Smart card details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
usrdtl_card_user_id	_varchar_20	varchar(20)	No	userid	Yes
usrdtl_card_uniqueid	_varchar_64	varchar(64)	Yes	card uniqueid	No
usrdtl_card_genid	_varchar_30	varchar(30)	Yes	generated card id	No
usrdtl_card_info	_varchar_30	varchar(30)	Yes	card info	No
usrdtl_card_appln_cd	_varchar_15	varchar(15)	No	card appln code	Yes
usrdtl_card_type	_varchar_15	varchar(15)	No	card type	No
usrdtl_card_status_cd	_varchar_2	varchar(2)	No	card status code	No
usrdtl_card_remarks	_varchar_255	varchar(255)	Yes	card remarks	No
usrdtl_card_iss_dt	_datetime_8	datetime(8)	Yes	card issue date	No
usrdtl_card_exp_dt	_datetime_8	datetime(8)	Yes	card expire date	No
usrdtl_card_timestamp	_numeric_10_0	numeric(10)	Yes	timestamp	No
usrdtl_card_createdby	_varchar_10	varchar(10)	Yes	createdby	No
usrdtl_card_createddate	_datetime_8	datetime(8)	Yes	createddate	No
usrdtl_card_modifiedby	_varchar_10	varchar(10)	Yes	modifiedby	No
usrdtl_card_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	sci_userstatus_mst
Comment :	User status master details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
user_status_cd	_varchar_2	varchar(2)	No	status code	Yes
user_status_desc	_varchar_15	varchar(15)	Yes	status description	No

Table Name :	sci_user_enroll_mst
Comment :	Enrollment master details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
enrmst_card_appln_cd	_varchar_15	varchar(15)	No	appln code	No
enrmst_screen_cd	_varchar_20	varchar(20)	No	screen code	Yes
enrmst_ouinstid	_numeric_4_0	numeric(4)	No	ouinstance	Yes
enrmst_card_user_id	_varchar_20	varchar(20)	No	userid	Yes
enrmst_user_status_cd	_varchar_2	varchar(2)	No	status code	No
enrmst_remarks	_varchar_255	varchar(255)	Yes	remarks	No
enrmst_timestamp	_numeric_10_0	numeric(10)	Yes	timestamp	No
enrmst_createdby	_varchar_10	varchar(10)	Yes	createdby	No
enrmst_createddate	_datetime_8	datetime(8)	Yes	createddate	No
enrmst_modifiedby	_varchar_10	varchar(10)	Yes	modifiedby	No
enrmst_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	sci_user_inactivecard_dtl
Comment :	Inactive card details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
usrdtl_card_user_id	_varchar_20	varchar(20)	No	userid	No
usrdtl_card_uniqueid	_varchar_64	varchar(64)	No	uniqueid	No
usrdtl_card_genid	_varchar_30	varchar(30)	No	generated id	No
usrdtl_card_info	_varchar_30	varchar(30)	Yes	card info	No
usrdtl_card_appln_cd	_varchar_15	varchar(15)	No	appln code	No
usrdtl_card_type	_varchar_15	varchar(15)	No	card type	No
usrdtl_card_status_cd	_varchar_2	varchar(2)	No	status cd	No
usrdtl_card_remarks	_varchar_255	varchar(255)	Yes	card remarks	No
usrdtl_card_iss_dt	_datetime_8	datetime(8)	Yes	card issue date	No
usrdtl_card_exp_dt	_datetime_8	datetime(8)	Yes	card expire date	No
usrdtl_card_timestamp	_numeric_10_0	numeric(10)	Yes	timestamp	No
usrdtl_card_createdby	_varchar_10	varchar(10)	Yes	createdby	No
usrdtl_card_createddate	_datetime_8	datetime(8)	Yes	createddate	No
usrdtl_card_modifiedby	_varchar_10	varchar(10)	Yes	modifiedby	No
usrdtl_card_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
usrdtl_card_reissdt	_datetime_8	datetime(8)	Yes	card reissdate	No