COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID PK COMMENTS
ID NUMBER No null 1 1 Primary Key
MAP_ID_FK NUMBER No null 2 null The map to which this rule belongs //PARENTFIELD
SOURCE_DATA_TYPE_NAME VARCHAR2(4000 BYTE) No null 3 null Source data type
SOURCE_PRECISION NUMBER Yes null 4 null Precison to match
SOURCE_SCALE NUMBER Yes null 5 null scale to match
TARGET_DATA_TYPE_NAME VARCHAR2(4000 BYTE) No null 6 null data type name to transform to
TARGET_PRECISION NUMBER Yes null 7 null precision to map to
TARGET_SCALE NUMBER Yes null 8 null scale to map to
SECURITY_GROUP_ID NUMBER No 0 9 null null
CREATED_ON DATE No sysdate 10 null null
CREATED_BY VARCHAR2(255 BYTE) Yes null 11 null null
LAST_UPDATED_ON DATE Yes null 12 null null
LAST_UPDATED_BY VARCHAR2(255 BYTE) Yes null 13 null null