Name TRANSFER_FILE
Comment Transfer file table

Column
Name Is PK Is FK UDP Datatype Null Option Comment
TRANSFER_JOB_ID Yes No NUMBER(20) NOT NULL Transfer job ID
TITLE No No VARCHAR2(255) NOT NULL Title of transfer job id
FILE_PATH No No VARCHAR2(255) NULL File path of transfer file
STAGE No No VARCHAR2(3) NULL Stage of transfer (TXR, TXN, etc.)
TRANSFER_DIRECTION No No VARCHAR2(50) NULL Import or export
COUNTRY_CODE No No VARCHAR2(10) NULL Country Code
DISPOSITION_STATUS No No VARCHAR2(1) NULL Active or Inactive
CREATED_BY No No VARCHAR2(20) NULL Created By
CREATED_DATE No No DATE NOT NULL Created Date
MODIFIED_BY No No VARCHAR2(20) NULL Modified By
MODIFIED_DATE No No DATE NOT NULL Modified Date
SUBMITTER_ID No Yes VARCHAR2(20) NULL User ID
ORGANIZATION_ID No Yes NUMBER(20) NULL Unique System Assigned ID
SUBMITTAL_COUNT No No INTEGER NULL Submittal Count
STATUS No No VARCHAR2(20) NULL Status
INVENTORY_ID No Yes NUMBER(20) NULL Unique System Assigned ID
UDP(s) of "TRANSFER_JOB_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "TITLE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "FILE_PATH" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "STAGE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "TRANSFER_DIRECTION" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "COUNTRY_CODE" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "DISPOSITION_STATUS" 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 "SUBMITTER_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "ORGANIZATION_ID" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "SUBMITTAL_COUNT" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "STATUS" Column
Range Check Null Check Valid Table/Values
None None None
UDP(s) of "INVENTORY_ID" Column
Range Check Null Check Valid Table/Values
None None None
Index
Name Member
TransferFilePrimaryKey
XIF2TRANSFER_FILE
XIF3TRANSFER_FILE
XIF4TRANSFER_FILE
Member(s) of "TransferFilePrimaryKey" Index
Column
Name
TRANSFER_JOB_ID
Member(s) of "XIF2TRANSFER_FILE" Index
Column
Name
ORGANIZATION_ID
Member(s) of "XIF3TRANSFER_FILE" Index
Column
Name
SUBMITTER_ID
Member(s) of "XIF4TRANSFER_FILE" Index
Column
Name
INVENTORY_ID
Child Relationship
Child Table
Name
POINT_EP
Child Table
Name
POINT_PE
Child Table
Name
POINT_EM
Child Table
Name
POINT_CE
Child Table
Name
POINT_ER
Child Table
Name
POINT_EU
Child Table
Name
POINT_SI
Child Table
Name
ONROAD_EM
Child Table
Name
ONROAD_PE
Child Table
Name
BIOGENIC_EM
Child Table
Name
ACTIVITY_FIRE_DETAIL
Child Table
Name
TRIBAL_DATA_COVERAGE
Child Table
Name
NOTE
Child Table
Name
ACTIVITY_PERMIT
Child Table
Name
ACTIVITY_DETAIL
Child Table
Name
ACTIVITY_METEOROLOGICAL_DETAIL
Child Table
Name
AREA_EM
Child Table
Name
AREA_PE
Child Table
Name
AREA_CE
Child Table
Name
AREA_EP
Child Table
Name
TR
Child Table
Name
TRANSFER_TABLE
Child Table
Name
TRANSFER_LOG
Parent Relationship
Parent Table
Name
INVENTORY
Parent Table
Name
EDMS_USER
Parent Table
Name
ORGANIZATION
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 ;

/