| Name | TRIBAL_DATA_COVERAGE |
| Comment | Tribal data coverage |
| Column |
| Name | Is PK | Is FK | UDP | Datatype | Null Option | Comment |
| TRANSFER_JOB_ID | Yes | Yes |
|
NUMBER(20) | NOT NULL | Transfer job ID |
| STATE_COUNTY_FIPS_CODE | Yes | Yes |
|
VARCHAR2(5) | NOT NULL | Concatenated State and County FIPS Code |
| TRIBAL_CODE | Yes | Yes |
|
VARCHAR2(255) | NOT NULL | Tribal code |
| SECTOR_CODE | Yes | Yes |
|
VARCHAR2(2) | NOT NULL | Sector Code |
| COUNTY_INCLUDES_RESERVATION | No | No |
|
VARCHAR2(1) | NULL | County Includes Reservation |
| NAR_ACCOUNTING_TYPE | No | No |
|
INTEGER | NULL | NAR Accounting Type |
| 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 |
| UDP(s) of "TRANSFER_JOB_ID" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "STATE_COUNTY_FIPS_CODE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "TRIBAL_CODE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "SECTOR_CODE" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "COUNTY_INCLUDES_RESERVATION" Column |
| Range Check | Null Check | Valid Table/Values |
| None | None | None |
| UDP(s) of "NAR_ACCOUNTING_TYPE" 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 |
| Index |
| Name | Member |
| XPKTRIBAL_DATA_COVERAGE |
|
| XIF2TRIBAL_DATA_COVERAGE |
|
| XIF3TRIBAL_DATA_COVERAGE |
|
| XIF4TRIBAL_DATA_COVERAGE |
|
| XIF5TRIBAL_DATA_COVERAGE |
|
| Member(s) of "XPKTRIBAL_DATA_COVERAGE" Index |
| Column |
| Name |
| TRANSFER_JOB_ID |
| Column |
| Name |
| STATE_COUNTY_FIPS_CODE |
| Column |
| Name |
| TRIBAL_CODE |
| Column |
| Name |
| SECTOR_CODE |
| Member(s) of "XIF2TRIBAL_DATA_COVERAGE" Index |
| Column |
| Name |
| TRANSFER_JOB_ID |
| Member(s) of "XIF3TRIBAL_DATA_COVERAGE" Index |
| Column |
| Name |
| STATE_COUNTY_FIPS_CODE |
| Member(s) of "XIF4TRIBAL_DATA_COVERAGE" Index |
| Column |
| Name |
| TRIBAL_CODE |
| Member(s) of "XIF5TRIBAL_DATA_COVERAGE" Index |
| Column |
| Name |
| SECTOR_CODE |
| Child Relationship |
| Parent Relationship |
| Parent Table |
| Name |
| SECTOR |
| Parent Table |
| Name |
| TRIBAL_CODE |
| Parent Table |
| Name |
| STATE_COUNTY_FIPS_QAQC |
| 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 |
create or replace trigger %TableOwner.%Substr(%TableName,1,21)_BI
before insert on %TableOwner.%TableName for each row
begin
:new.created_by := user;
:new.created_date := sysdate;
:new.modified_by := user;
:new.modified_date :=sysdate;
end ;
/
|