| Name | TRANSFER_LOG |
| Comment | Transfer log table |
| Column |
| Name | Is PK | Is FK | UDP | Datatype | Null Option | Comment |
| TRANSFER_LOG_ID | Yes | No |
|
NUMBER(20) | NOT NULL | Transfer log ID |
| TRANSFER_LOG_CODE | No | Yes |
|
NUMBER(20) | NULL | Activity Code for log id |
| TRANSFER_MODULE_NAME | No | No |
|
VARCHAR2(255) | NULL | Module Name |
| TRANSFER_LOG_TEXT | No | No |
|
VARCHAR2(255) | NULL | Log Text |
| TRANSFER_LOG_COUNT | No | No |
|
NUMBER(20) | NULL | Log Count |
| TIMESTAMP | No | No |
|
DATE | NULL | Timestamp |
| TRANSFER_TABLE_ID | No | Yes |
|
NUMBER(20) | NULL | Transfer table id |
| CREATED_BY | No | No |
|
VARCHAR2(20) | NULL | Created by User ID |
| CREATED_DATE | No | No |
|
DATE | NULL | Created Date |
| MODIFIED_BY | No | No |
|
VARCHAR2(20) | NULL | Modified by User ID |
| MODIFIED_DATE | No | No |
|
DATE | NOT NULL | Modified Date |
| TRANSFER_JOB_ID | No | Yes |
|
NUMBER(20) | NULL | Transfer job ID |
| UDP(s) of "TRANSFER_LOG_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_LOG_CODE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_MODULE_NAME" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_LOG_TEXT" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_LOG_COUNT" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TIMESTAMP" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_TABLE_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "CREATED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_BY" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "MODIFIED_DATE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRANSFER_JOB_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| Index |
| Name | Member |
| TransferLogPrimaryKey |
|
| XIF1TRANSFER_LOG |
|
| XIF2TRANSFER_LOG |
|
| XIF3TRANSFER_LOG |
|
| Member(s) of "TransferLogPrimaryKey" Index |
| Column |
| Name |
| TRANSFER_LOG_ID |
| Member(s) of "XIF1TRANSFER_LOG" Index |
| Column |
| Name |
| TRANSFER_JOB_ID |
| Member(s) of "XIF2TRANSFER_LOG" Index |
| Column |
| Name |
| TRANSFER_TABLE_ID |
| Member(s) of "XIF3TRANSFER_LOG" Index |
| Column |
| Name |
| TRANSFER_LOG_CODE |
| Child Relationship |
| Parent Relationship |
| Parent Table |
| Name |
| TRANSFER_LOG_CODES |
| Parent Table |
| Name |
| TRANSFER_TABLE |
| Parent Table |
| Name |
| TRANSFER_FILE |
| Script |
| Name | Code |
| BU |
create or replace trigger %TableOwner.%Substr(%TableName,1,21)_BU
before update on %TableOwner.%TableName for each row
begin
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|
| BI_SEQ |
create or replace trigger %TableOwner.%Substr(%TableName,1,17)_BI_SEQ
before insert on %TableOwner.%TableName for each row
declare new_id number;
begin
select %TableOwner.SEQ_%TableName.nextval into new_id from dual;
:new.%PK() := new_id;
:new.created_by := user;
:new.created_date := sysdate;
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|