Data Dictionary - Smart Card Interface |
|||||
|
|
|||||
|
Table Name CM_Cmgate_gate_dtl |
|
||||
|
|
|||||
|
Table Comment Smart Card Application Group |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
card_appln_grp_cd |
varchar(15) |
NOT NULL |
Smart Card Application Group Code |
Yes |
No |
|
card_appln_grp_desc |
varchar(20) |
NULL |
Smart Card Application Group Description |
No |
No |
|
|
|||||
|
Table Name sci_cardappln_mst |
|
||||
|
|
|||||
|
Table Comment Smart Card Application-Master |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
card_appln_cd |
varchar(15) |
NOT NULL |
Card Application Code |
Yes |
No |
|
card_appln_grp_cd |
varchar(15) |
NULL |
Card Application Group Code |
No |
No |
|
card_appln_desc |
varchar(20) |
NULL |
Description for Card Application |
No |
No |
|
card_appln_fileaddr |
varchar(15) |
NULL |
File Address for Card Application |
No |
No |
|
|
|||||
|
Table Name sci_cardidgen_dtl |
|
||||
|
|
|||||
|
Table Comment Smart Card ID Generation Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cardidgen_prefix |
char(18) |
NOT NULL |
Prefix of Card ID Generation |
Yes |
No |
|
cardidgen_lastgen_no |
numeric(5,3) |
NULL |
Card ID Last Generation No |
No |
No |
|
cardidgen_lastgen_dt |
datetime |
NULL |
Card ID Last Generation Details |
No |
No |
|
|
|||||
|
Table Name sci_cardstatus_mst |
|
||||
|
|
|||||
|
Table Comment Status of the Master Smart Card |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
card_status_cd |
varchar(20) |
NOT NULL |
Card Status Code |
Yes |
No |
|
card_status_desc |
varchar(15) |
NULL |
Description Of Card Status |
No |
No |
|
|
|||||
|
Table Name sci_cardtype_mst |
|
||||
|
|
|||||
|
Table Comment Master Card Type |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
card_type |
varchar(15) |
NOT NULL |
Type Of The Card |
Yes |
No |
|
card_type_desc |
varchar(30) |
NULL |
Description Of The Card Type |
No |
No |
|
|
|||||
|
Table Name sci_cardusage_log |
|
||||
|
|
|||||
|
Table Comment Smart Card Usage Log |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
card_user_id |
varchar(20) |
NULL |
Smart Card User ID |
No |
No |
|
card_uniqueid |
varchar |
NULL |
Smart Card Unique ID |
No |
No |
|
card_appln_cd |
varchar(15) |
NULL |
Card Application Code |
No |
No |
|
screen_cd |
varchar(20) |
NULL |
Screen Code |
No |
No |
|
screen_ou |
numeric(10,0) |
NULL |
Screen OU |
No |
No |
|
createdby |
varchar(15) |
NULL |
Created By |
No |
No |
|
createddate |
datetime |
NULL |
Date Of Creation |
No |
No |
|
|
|||||
|
Table Name sci_functiongrp_mst |
|
||||
|
|
|||||
|
Table Comment Smart Card Function Group Master |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
fgrp_screen_cd |
varchar(20) |
NOT NULL |
Function Group Screen Code |
Yes |
No |
|
frgp_card_appln_cd |
varchar(15) |
NULL |
Function Group Card Application Code |
No |
No |
|
fgrp_screen_desc |
varchar(20) |
NULL |
Screen Description for Smart Card Function Group |
No |
No |
|
fgrp_project_id |
varchar(40) |
NULL |
Project ID for Smart Card Function Group |
No |
No |
|
fgrp_component |
varchar(40) |
NULL |
Smart Card Function Group Component |
No |
No |
|
fgrp_activityid |
varchar(18) |
NULL |
Smart Card Function Group Activity ID |
No |
No |
|
fgrp_ilbocode |
varchar(20) |
NULL |
Smart Card Function Group ILBO Code |
No |
No |
|
fgrp_task |
varchar(20) |
NULL |
Smart Card Function Group Task |
No |
No |
|
|
|||||
|
Table Name sci_sys_config_at |
|
||||
|
|
|||||
|
Table Comment Smart Card System Configuration Attribute |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
config_at_code |
varchar(20) |
NOT NULL |
Configuration Attribute Code |
Yes |
No |
|
config_at_value |
varchar(40) |
NULL |
Configuration Attribute Value |
No |
No |
|
|
|||||
|
Table Name sci_sys_config_dtl |
|
||||
|
|
|||||
|
Table Comment Smart Card System Configuration Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
config_component |
varchar(40) |
NOT NULL |
Configuration Component |
Yes |
No |
|
config_screen_cd |
varchar(20) |
NOT NULL |
Configuration of Screen Code |
Yes |
No |
|
config_ouinstid |
bigint |
NOT NULL |
Configuration of OU Instance ID |
Yes |
No |
|
config_is_enabled |
varchar(1) |
NULL |
Configuration Is Enabled |
No |
No |
|
config_timestamp |
numeric(9,10) |
NULL |
Configuration For Timestamp |
No |
No |
|
config_createdby |
varchar(15) |
NULL |
Configuration for Created By |
No |
No |
|
config_createddate |
datetime |
NULL |
Configuration For Created Date |
No |
No |
|
config_modifiedby |
varchar(15) |
NULL |
Configuration for Modified By |
No |
No |
|
config_modifieddate |
datetime |
NULL |
Configuration For Modified Date |
No |
No |
|
|
|||||
|
Table Name sci_system_param_dtl |
|
||||
|
|
|||||
|
Table Comment Smart Card System Parameter Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
scisys_parameter_code |
varchar(20) |
NOT NULL |
Smart Card System Parameter Code |
Yes |
No |
|
scisys_parameter_value |
varchar(40) |
NULL |
Smart Card System Parameter Value |
No |
No |
|
scisys_parameter_text |
varchar(80) |
NULL |
Smart Card System Parameter Text |
No |
No |
|
scisys_created_by |
varchar(30) |
NULL |
Smart Card System Parameter created by |
No |
No |
|
scisys_created_date |
datetime |
NULL |
Smart Card System Parameter Created Date |
No |
No |
|
scisys_modified_by |
varchar(30) |
NULL |
Smart Card System Parameter Modified By |
No |
No |
|
scisys_modified_date |
datetime |
NULL |
Smart Card System Parameter Modified Date |
No |
No |
|
scisys_timestamp |
numeric(9,18) |
NULL |
Smart Card System Parameter Timestamp |
No |
No |
|
|
|||||
|
Table Name sci_user_enroll_mst |
|
||||
|
|
|||||
|
Table Comment Smart Card User Enrollment Master |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
enrmst_card_user_id |
varchar(20) |
NOT NULL |
Enrollment Master Card User ID |
Yes |
No |
|
enrmst_ouinstid |
numeric(5,4) |
NOT NULL |
Enrollment Master Card OU Instance ID |
Yes |
No |
|
enrmst_screen_cd |
varchar(20) |
NOT NULL |
Enrollment Master Card Screen Code |
Yes |
No |
|
enrmst_card_appln_cd |
varchar(15) |
NOT NULL |
Enrollment Master Card Application Code |
No |
No |
|
enrmst_user_status_cd |
varchar(20) |
NOT NULL |
Enrollment Master Card User Status Code |
No |
No |
|
enrmst_remarks |
varchar(255) |
NULL |
Enrollment Master Card Remarks |
No |
No |
|
enrmst_timestamp |
numeric(9,10) |
NULL |
Enrollment Master Card Timestamp |
No |
No |
|
enrmst_createdby |
varchar(10) |
NULL |
Enrollment Master Card Created By |
No |
No |
|
enrmst_createddate |
datetime |
NULL |
Enrollment Master Card Created Date |
No |
No |
|
enrmst_modifiedby |
varchar(10) |
NULL |
Enrollment Master Card Modified By |
No |
No |
|
enrmst_modifieddate |
datetime |
NULL |
Enrollment Master Card Modified Date |
No |
No |
|
|
|||||
|
Table Name sci_user_inactivecard_dtl |
|
||||
|
|
|||||
|
Table Comment Smart Card User’s Inactive Card Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
usrdtl_card_user_id |
varchar(20) |
NULL |
Smart Card User ID Details |
No |
No |
|
usrdtl_card_uniqueid |
varchar |
NULL |
User’s Unique ID Details |
No |
No |
|
usrdtl_card_genid |
varchar(30) |
NULL |
Card Generation ID |
No |
No |
|
usrdtl_card_info |
varchar(30) |
NULL |
Card Information |
No |
No |
|
usrdtl_card_appln_cd |
varchar(15) |
NULL |
Card Application Code |
No |
No |
|
usrdtl_card_type |
varchar(15) |
NULL |
Card Type |
No |
No |
|
usrdtl_card_status_cd |
varchar |
NULL |
Card Status Code |
No |
No |
|
usrdtl_card_remarks |
varchar(255) |
NULL |
Card Remarks |
No |
No |
|
usrdtl_card_iss_dt |
datetime |
NULL |
Card Issue Date |
No |
No |
|
usrdtl_card_exp_dt |
datetime |
NULL |
Smart Card Expiry Date |
No |
No |
|
usrdtl_card_timestamp |
numeric(9,10) |
NULL |
Smart Card Timestamp |
No |
No |
|
usrdtl_card_createdby |
varchar(10) |
NULL |
Smart Card Created By |
No |
No |
|
usrdtl_card_createddate |
datetime |
NULL |
Created Date Of Smart Card User Details |
No |
No |
|
usrdtl_card_modifiedby |
varchar(10) |
NULL |
Card Modified By |
No |
No |
|
usrdtl_card_modifieddate |
datetime |
NULL |
Modified Date |
No |
No |
|
usrdtl_card_reissdt |
datetime |
NULL |
ReIssue Date of Smart Card |
No |
No |
|
|
|||||
|
Table Name sci_usercard_dtl |
|
||||
|
|
|||||
|
Table Comment User Card Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
usrdtl_card_user_id |
varchar(20) |
NOT NULL |
Card User ID |
Yes |
No |
|
usrdtl_card_appln_cd |
varchar(15) |
NOT NULL |
Card Application Code Details |
Yes |
No |
|
usrdtl_card_uniqueid |
varchar(20) |
NULL |
Unique ID of Card |
No |
No |
|
usrdtl_card_genid |
varchar(30) |
NULL |
Card Generation ID |
No |
No |
|
usrdtl_card_info |
varchar(30) |
NULL |
Card Information |
No |
No |
|
usrdtl_card_type |
varchar(15) |
NULL |
Card Type |
No |
No |
|
usrdtl_card_status_cd |
varchar |
NULL |
Card Status Code |
No |
No |
|
usrdtl_card_remarks |
varchar(255) |
NULL |
Card Remarks |
No |
No |
|
usrdtl_card_iss_dt |
datetime |
NULL |
Card Issue Date |
No |
No |
|
usrdtl_card_exp_dt |
datetime |
NULL |
Card Expiry Date |
No |
No |
|
usrdtl_card_timestamp |
numeric(9,10) |
NULL |
Smart Card TimeStamp |
No |
No |
|
usrdtl_card_createdby |
varchar(10) |
NULL |
Smart Card Created By |
No |
No |
|
usrdtl_card_createddate |
datetime |
NULL |
Card Created Date |
No |
No |
|
usrdtl_card_modifiedby |
varchar(10) |
NULL |
Card Modified By |
No |
No |
|
usrdtl_card_modifieddate |
datetime |
NULL |
Card Modified Date |
No |
No |
|
|
|||||
|
Table Name sci_userstatus_mst |
|
||||
|
|
|||||
|
Table Comment User Status Of Smart Card Master |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
user_status_cd |
varchar(20) |
NOT NULL |
Smart Card User Status Code |
Yes |
No |
|
user_status_desc |
varchar(15) |
NULL |
Smart Card User Status Description |
No |
No |
|
|
|
|
|
|
|