Entity 'APPACTION'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK RULEID Number YES NO
PK ACTIONSEQ Number YES NO
PFK USERGROUPID Number YES NO
RULEFAMILY Number YES NO
ACTIONATTRID Number NO NO
ACTIONTYPE Varchar2 NO NO
ACTIONVALUE Varchar2 NO NO
ACTIONSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003942 Identifying GROUPS APPACTION 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'APPRULE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK RULEID Number YES NO
PK RULESEQ Number YES NO
PFK USERGROUPID Number YES NO
RULEFAMILY Number YES NO
RULEPRECEDENCE Number NO NO
RULETYPE Varchar2 YES NO
RULEINTERRULEOPER Varchar2 YES NO
RULEATTRID Number NO NO
RULEATTRRELATIVE Varchar2 NO NO
RULEOPERATOR Varchar2 YES NO
RULEVALUE Varchar2 NO NO
RULESTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003943 Identifying GROUPS APPRULE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'ATTR_CODE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK CODECAT Number YES NO
PK CODEVALUE Varchar2 YES NO
PFK USERGROUPID Number YES NO
PARENTCODEVALUE Varchar2 YES NO
DECODEVALUE Varchar2 NO NO
CODESTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003948 Identifying CODECATEGORY ATTR_CODE 1:N
SYS_C003949 Identifying GROUPS ATTR_CODE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'ATTRCODEXREF'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK ATTRID Number YES NO
PFK USERGROUPID Number YES NO
FK CODECAT Number NO NO
MAXCODERESPONSES Number NO NO
RESPONSEORDER Varchar2 NO NO
XREFSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003945 Identifying ATTRIBUTE ATTRCODEXREF 1:N
SYS_C003944 Non-identifying CODECATEGORY ATTRCODEXREF 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'ATTRDBXREF'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK ATTRID Number YES NO
TABLE_NAME Varchar2 YES NO
FIELD Varchar2 YES NO
MOVE Varchar2 YES NO
VISIBLE Varchar2 YES NO
FTYPE Varchar2 NO NO
ATTR_DATATYPE Number NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'ATTRIBUTE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK ATTRID Number YES NO
PFK USERGROUPID Number YES NO
ATTR_DESC Varchar2 NO NO
WINDOWID Number NO NO
ATTR_TYPE Varchar2 NO NO
ATTR_LENGTH Number NO NO
ATTR_APPLDEFAULTSEC Number YES NO
ATTR_APPLDEFAULTRQMT Number YES NO
ATTR_LOSTFOCUSMASK Varchar2 NO NO
ATTR_STATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003945 Identifying ATTRIBUTE ATTRCODEXREF 1:N
SYS_C003947 Identifying ATTRIBUTE ATTRIBUTE_VISIBILITY 1:N
SYS_C003965 Identifying ATTRIBUTE USERCOMPSECXREF 1:N
SYS_C003946 Identifying GROUPS ATTRIBUTE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'ATTRIBUTE_VISIBILITY'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK ATTRID Number YES NO
PFK USERGROUPID Number YES NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003947 Identifying ATTRIBUTE ATTRIBUTE_VISIBILITY 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BI_FILE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK PREFIX Varchar2 YES NO
PK FILESEQNUM Number(x,y) YES NO
FILENAME Varchar2 NO NO
FILESIZE Number(x,y) NO NO
DATAVERSION Varchar2 NO NO
NUMFD Number(x,y) NO NO
NUMINC Number(x,y) NO NO
BEGIN_TIME Date NO NO
END_TIME Date NO NO
TYPE_OK Varchar2 NO NO
RESUME_VALID Number(x,y) NO NO
RESUME_INVALID Number(x,y) NO NO
RESUME_DELETED Number(x,y) NO NO
RESUME_FAILED Number(x,y) NO NO
WAS_INTERRUPTED Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003951 Identifying BI_FILE BI_FIREDEPT 1:N
SYS_C003937 Identifying BI_FILE BI_INCIDENT 1:N
SYS_C003950 Identifying BI_IMPORT BI_FILE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BI_FIREDEPT'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK PREFIX Varchar2 YES NO
PFK FILESEQNUM Number(x,y) YES NO
PK RECSEQNUM Number(x,y) YES NO
FDID Varchar2 NO NO
WAS_IMPORTED Varchar2 NO NO
STATUS Varchar2 NO NO
ACTION_TYPE Number(x,y) NO NO
VALID Varchar2 NO NO
MARKER Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003951 Identifying BI_FILE BI_FIREDEPT 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BI_IMPORT'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK PREFIX Varchar2 YES NO
USERNAME Varchar2 NO NO
USERSTATE Varchar2 NO NO
USEREMAIL Varchar2 NO NO
ACCEPT_INVALID Varchar2 NO NO
OVERWRITE_EXISTING Varchar2 NO NO
NUMFILES Number(x,y) NO NO
BEGIN_TIME Date NO NO
END_TIME Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003950 Identifying BI_IMPORT BI_FILE 1:N
SYS_C003936 Identifying BI_IMPORT BI_IMPORT_FILELIST 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BI_IMPORT_FILELIST'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK PREFIX Varchar2 YES NO
PK FILENAME Varchar2 YES NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003936 Identifying BI_IMPORT BI_IMPORT_FILELIST 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BI_INCIDENT'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK PREFIX Varchar2 YES NO
PFK FILESEQNUM Number(x,y) YES NO
PK RECSEQNUM Number(x,y) YES NO
INCIDENTID Varchar2 NO NO
FDID Varchar2 NO NO
INCDATE Date NO NO
WAS_IMPORTED Varchar2 NO NO
STATUS Varchar2 NO NO
ACTION_TYPE Number(x,y) NO NO
VALID Varchar2 NO NO
MARKER Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003937 Identifying BI_FILE BI_INCIDENT 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BP_BATCH_JOB'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK BATCH_JOB_ID Number YES NO
BATCH_JOB_TYPE Varchar2 NO NO
BATCH_JOB_NAME Varchar2 NO NO
USERSTATE Varchar2 NO NO
USERNAME Varchar2 NO NO
USEREMAIL Varchar2 NO NO
STATUS Varchar2 NO NO
SUBMITTED_AT Date NO NO
ENTERED_QUEUE_AT Date NO NO
PROCESSING_STARTED_AT Date NO NO
PROCESSING_COMPLETED_AT Date NO NO
CANCELLED_AT Date NO NO
NUM_ITEMS_MATCHING Number NO NO
NUM_ITEMS_VISITED Number NO NO

 User-defined variables
Name Value
Owner BATCH_PROCESSOR
Tablespace for Primary key INDX
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BP_EXPORT_FIRE_DEPTS_TASK'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
BATCH_JOB_ID Number NO NO
SCOPE_USERGROUPID Number NO NO
NUMBER_OF_EXPORT_FILES Number NO NO
EXPORT_FILES_PREFIX Varchar2 NO NO

 User-defined variables
Name Value
Owner BATCH_PROCESSOR
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BP_EXPORT_INCIDENTS_TASK'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
BATCH_JOB_ID Number NO NO
SCOPE_EXPOSURE Number NO NO
SCOPE_USERGROUPID Number NO NO
SCOPE_FROM_DATE Date NO NO
SCOPE_TO_DATE Date NO NO
SCOPE_IN_NFIRSLOADVERSION Varchar2 NO NO
SCOPE_IN_NUM Varchar2 NO NO
SCOPE_IN_STATUS Varchar2 NO NO
SCOPE_IS_RELEASED Varchar2 NO NO
SCOPE_MODIFIED_SINCE Date NO NO
SCOPE_FROM_IN_TYPE Varchar2 NO NO
SCOPE_TO_IN_TYPE Varchar2 NO NO
SCOPE_FROM_IN_PROPERTYUSE Varchar2 NO NO
SCOPE_TO_IN_PROPERTYUSE Varchar2 NO NO
INCIDENT_SET_ID Number NO NO
NUMBER_OF_EXPORT_FILES Number NO NO
EXPORT_FILES_PREFIX Varchar2 NO NO

 User-defined variables
Name Value
Owner BATCH_PROCESSOR
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'BP_INCIDENT_SET'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INCIDENT_SET_ID Number NO NO
INCIDENTID Number NO NO

 User-defined variables
Name Value
Owner BATCH_PROCESSOR
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CAS_CIVILIAN'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK CASUALTYNUM Number YES NO
CC_FNAME Varchar2 NO NO
CC_MI Varchar2 NO NO
CC_LNAME Varchar2 NO NO
CC_SUFFIX Varchar2 NO NO
CC_GENDER Varchar2 NO NO
CC_AGE Number(x,y) NO NO
CC_RACE Varchar2 NO NO
CC_ETHNICITY Varchar2 NO NO
CC_AFFILIATION Varchar2 NO NO
CC_INJURYDATE Date NO NO
CC_SEVERITY Varchar2 NO NO
CC_CAUSEOFINJURY Varchar2 NO NO
CC_ACTIVITYWHENINJURED Varchar2 NO NO
CC_LOCATIONATINCIDENT Varchar2 NO NO
CC_LOCATIONWHENINJURED Varchar2 NO NO
CC_FLOORATSTART Number NO NO
CC_FLOORATSTARTBELOWGRADE Varchar2 NO NO
CC_FLOORATINJURED Number NO NO
CC_FLOORATINJUREDBELOWGRADE Varchar2 NO NO
CC_SPECIFICLOCATION Varchar2 NO NO
CC_PRIMARYSYMPTOM Varchar2 NO NO
CC_PRIMARYBODYPART Varchar2 NO NO
CC_DISPOSITION Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003938 Identifying INCIDENTKEY CAS_CIVILIAN 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CAS_EMS'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK CASUALTYNUM Number YES NO
EMS_ARRPATIENTDATE Date NO NO
EMS_PATIENTTRANDATE Date NO NO
EMS_PROVIDERASSESS Varchar2 NO NO
EMS_AGE Number(x,y) NO NO
EMS_GENDER Varchar2 NO NO
EMS_RACE Varchar2 NO NO
EMS_ETHNICITY Varchar2 NO NO
EMS_OTHERFACTORS Varchar2 NO NO
EMS_CAUSEOFILLNESS Varchar2 NO NO
EMS_INITARRESTRYTHM Varchar2 NO NO
EMS_INITIALCARELEVEL Varchar2 NO NO
EMS_HIGHESTCARELEVEL Varchar2 NO NO
EMS_PATIENTSTATUS Varchar2 NO NO
EMS_TRANSFERSTATUS Varchar2 NO NO
EMS_DISPOSITION Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003939 Identifying INCIDENTKEY CAS_EMS 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CAS_EQUIP_FAIL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PFK CASUALTYNUM Number YES NO
PK EQUIP_SEQ Number YES NO
FS_EQUIPITEM Varchar2 NO NO
FS_EQUIPPROB Varchar2 NO NO
FS_MANUFACTURER Varchar2 NO NO
FS_MODEL Varchar2 NO NO
FS_SERIALNUM Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003972 Identifying CAS_FIRESERVICE CAS_EQUIP_FAIL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CAS_FIRESERVICE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK CASUALTYNUM Number YES NO
FS_ID Varchar2 NO NO
FS_LNAME Varchar2 NO NO
FS_FNAME Varchar2 NO NO
FS_MI Varchar2 NO NO
FS_SUFFIX Varchar2 NO NO
FS_GENDER Varchar2 NO NO
FS_CAREER Varchar2 NO NO
FS_AGE Number NO NO
FS_INJURYDATE Date NO NO
FS_RESPONSES Number NO NO
FS_USUALASSIGNMENT Varchar2 NO NO
FS_CONDITIONPRIOR Varchar2 NO NO
FS_SEVERITY Varchar2 NO NO
FS_TAKENTO Varchar2 NO NO
FS_ACTIVITYATINJURY Varchar2 NO NO
FS_PRIMARYSYMPTOM Varchar2 NO NO
FS_PRIMARYBODYPART Varchar2 NO NO
FS_CAUSEOFINJURY Varchar2 NO NO
FS_CONTRIBUTINGFACTOR Varchar2 NO NO
FS_OBJECTINVOLVED Varchar2 NO NO
FS_WHEREOCCUR Varchar2 NO NO
FS_RELATIONTOSTRUCTURE Varchar2 NO NO
FS_STORIESFROMGRADE Number NO NO
FS_STORIESBELOWGRADE Varchar2 NO NO
FS_SPECIFICLOCATION Varchar2 NO NO
FS_VEHICLETYPE Varchar2 NO NO
FS_PROTEQUIPFACTOR Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003972 Identifying CAS_FIRESERVICE CAS_EQUIP_FAIL 1:N
SYS_C003940 Identifying INCIDENTKEY CAS_FIRESERVICE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHANGE_LOG'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK LOGID Number YES NO
LOGDATE Date NO NO
USERNAME Varchar2 NO NO
FDIDSTATE Varchar2 NO NO
FK ENTITYTYPE Number NO NO
FK CHANGETYPE/LOGENTRYTYPE Number NO NO
SOURCEGROUPID Number NO NO
TARGETGROUPID Number NO NO
FROMDATE Date NO NO
TODATE Date NO NO
STATUS Varchar2 NO NO
DATAVERSION Varchar2 NO NO
INCIDENTNUMBER Varchar2 NO NO
EXPOSURENUMBER Number NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
FK_CHANGELOGGROUP Non-identifying CHANGE_LOG CHANGE_LOG_GROUP 1:N
FK_CHANGELOGINCIDENT Non-identifying CHANGE_LOG CHANGE_LOG_INCIDENT 1:N
FK_CHANGELOGLOGENTRYTYPE Non-identifying CHANGE_LOG_CHANGE_TYPE CHANGE_LOG 1:N
FK_CHANGELOGENTITYTYPE Non-identifying CHANGE_LOG_ENTITY_TYPE CHANGE_LOG 1:N

 User-defined variables
Name Value
Owner NFIRS_LOGGING
Tablespace for Primary key INDX
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHANGE_LOG_CHANGE_TYPE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK CHANGETYPE Number YES NO
DESCRIPTION Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
FK_CHANGELOGLOGENTRYTYPE Non-identifying CHANGE_LOG_CHANGE_TYPE CHANGE_LOG 1:N

 User-defined variables
Name Value
Owner NFIRS_LOGGING
Tablespace for Primary key INDX
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHANGE_LOG_ENTITY_TYPE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK ENTITYTYPE Number YES NO
DESCRIPTION Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
FK_CHANGELOGENTITYTYPE Non-identifying CHANGE_LOG_ENTITY_TYPE CHANGE_LOG 1:N
FK_CHANGELOGGROUPENTITYTYPE Non-identifying CHANGE_LOG_ENTITY_TYPE CHANGE_LOG_GROUP 1:N

 User-defined variables
Name Value
Owner NFIRS_LOGGING
Tablespace for Primary key INDX
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHANGE_LOG_GROUP'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
FK LOGID Number NO NO
FK ENTITYTYPE Number NO NO
GROUPID Number NO NO
GROUPORFDIDNAME Varchar2 NO NO
FDID Varchar2 NO NO
OLDPARENTGROUPID Number NO NO
OLDPARENTGROUPDESC Varchar2 NO NO
NEWPARENTGROUPID Number NO NO
NEWPARENTGROUPDESC Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
FK_CHANGELOGGROUP Non-identifying CHANGE_LOG CHANGE_LOG_GROUP 1:N
FK_CHANGELOGGROUPENTITYTYPE Non-identifying CHANGE_LOG_ENTITY_TYPE CHANGE_LOG_GROUP 1:N

 User-defined variables
Name Value
Owner NFIRS_LOGGING
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHANGE_LOG_INCIDENT'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
FK LOGID Number NO NO
FDID Varchar2 NO NO
INCIDENTNUMBER Varchar2 NO NO
EXPOSURENUMBER Number NO NO
INCIDENTALARMDATE Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
FK_CHANGELOGINCIDENT Non-identifying CHANGE_LOG CHANGE_LOG_INCIDENT 1:N

 User-defined variables
Name Value
Owner NFIRS_LOGGING
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CHEMICAL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK CHEMICALID Varchar2 YES NO
PFK USERGROUPID Number YES NO
CHEMICALNAME Varchar2 NO NO
UN_NUMBER Varchar2 NO NO
CAS_NUMBER Varchar2 NO NO
CHEMICALSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003941 Identifying GROUPS CHEMICAL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'CODECATEGORY'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK CODECAT Number YES NO
FK USERGROUPID Number NO NO
CODECATDESC Varchar2 NO NO
CODEGENERICLENGTH Number NO NO
CODECATSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003944 Non-identifying CODECATEGORY ATTRCODEXREF 1:N
SYS_C003948 Identifying CODECATEGORY ATTR_CODE 1:N
SYS_C003929 Non-identifying GROUPS CODECATEGORY 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'EQUIP_INVOLVED'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK EQ_RECTYPE Varchar2 YES NO
EQ_BRAND Varchar2 NO NO
EQ_MODEL Varchar2 NO NO
EQ_SERIALNUM Varchar2 NO NO
EQ_YEAR Number(x,y) NO NO
EQ_POWER Varchar2 NO NO
EQ_PORTABILITY Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003930 Identifying INCIDENTKEY EQUIP_INVOLVED 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'EVENTMESSAGE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK EVENTNUM Number YES NO
PFK USERGROUPID Number YES NO
EVENTCLASS Varchar2 NO NO
EVENTCRIT Number NO NO
EVENTMSG Varchar2 NO NO
EVENTSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003931 Identifying GROUPS EVENTMESSAGE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_APPARATUS'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK FDID Varchar2 YES NO
PFK FDIDSTATE Varchar2 YES NO
PK FD_APSEQ Number YES NO
FD_APID Varchar2 NO NO
FD_APTYPE Varchar2 NO NO
FD_APNAME Varchar2 NO NO
FD_APINSERVICEDATE Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003932 Identifying FD_HEADER FD_APPARATUS 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_APPARATUS_1025'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
FDID Varchar2 YES NO
FDIDSTATE Varchar2 YES NO
FD_APSEQ Number YES NO
FD_APID Varchar2 NO NO
FD_APTYPE Varchar2 NO NO
FD_APNAME Varchar2 NO NO
FD_APINSERVICEDATE Date NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_HEADER'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK FDID Varchar2 YES NO
PK FDIDSTATE Varchar2 YES NO
FD_NAME Varchar2 NO NO
FD_STREETNUM Varchar2 NO NO
FD_STREETPREFIX Varchar2 NO NO
FD_STREETHIGHWAY Varchar2 NO NO
FD_STREETTYPE Varchar2 NO NO
FD_STREETSUFFIX Varchar2 NO NO
FD_CITY Varchar2 NO NO
FD_ZIP Varchar2 NO NO
FD_PHONE Varchar2 NO NO
FD_FAX Varchar2 NO NO
FD_EMAIL Varchar2 NO NO
FD_FIPSCOUNTYCODE Varchar2 NO NO
FD_NUMSTATIONS Number NO NO
FD_POPPROTECT Float NO NO
FD_POPDENSITY Varchar2 NO NO
FD_NUMPAIDFF Number NO NO
FD_NUMVOLFFPPC Number NO NO
FD_NUMVOLFF Number NO NO
FD_SQUAREMILES Number NO NO
FD_CURRENTINCIDENTSDATE Date NO NO
FD_VENDORID Varchar2 NO NO
FD_SOFTWAREID Varchar2 NO NO
FD_LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003932 Identifying FD_HEADER FD_APPARATUS 1:N
SYS_C003933 Identifying FD_HEADER FD_PERSONNEL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_HEADER_1025'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
FDID Varchar2 YES NO
FDIDSTATE Varchar2 YES NO
FD_NAME Varchar2 NO NO
FD_STREETNUM Varchar2 NO NO
FD_STREETPREFIX Varchar2 NO NO
FD_STREETHIGHWAY Varchar2 NO NO
FD_STREETTYPE Varchar2 NO NO
FD_STREETSUFFIX Varchar2 NO NO
FD_CITY Varchar2 NO NO
FD_ZIP Varchar2 NO NO
FD_PHONE Varchar2 NO NO
FD_FAX Varchar2 NO NO
FD_EMAIL Varchar2 NO NO
FD_FIPSCOUNTYCODE Varchar2 NO NO
FD_NUMSTATIONS Number NO NO
FD_POPPROTECT Float NO NO
FD_POPDENSITY Varchar2 NO NO
FD_NUMPAIDFF Number NO NO
FD_NUMVOLFFPPC Number NO NO
FD_NUMVOLFF Number NO NO
FD_SQUAREMILES Number NO NO
FD_CURRENTINCIDENTSDATE Date NO NO
FD_VENDORID Varchar2 NO NO
FD_SOFTWAREID Varchar2 NO NO
FD_LASTUPDATED Date NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_PERSONNEL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK FDID Varchar2 YES NO
PFK FDIDSTATE Varchar2 YES NO
PK FD_PERSSEQ Number YES NO
FD_PERSID Varchar2 NO NO
FD_LNAME Varchar2 NO NO
FD_FNAME Varchar2 NO NO
FD_MI Varchar2 NO NO
FD_SUFFIX Varchar2 NO NO
FD_RANK Varchar2 NO NO
FD_PERSPHONE1 Varchar2 NO NO
FD_PERSPHONE2 Varchar2 NO NO
FD_PERSEMAIL Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003933 Identifying FD_HEADER FD_PERSONNEL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_PERSONNEL_1025'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
FDID Varchar2 YES NO
FDIDSTATE Varchar2 YES NO
FD_PERSSEQ Number YES NO
FD_PERSID Varchar2 NO NO
FD_LNAME Varchar2 NO NO
FD_FNAME Varchar2 NO NO
FD_MI Varchar2 NO NO
FD_SUFFIX Varchar2 NO NO
FD_RANK Varchar2 NO NO
FD_PERSPHONE1 Varchar2 NO NO
FD_PERSPHONE2 Varchar2 NO NO
FD_PERSEMAIL Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FD_SOFTWARE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK FDID Varchar2 YES NO
PK FDID_STATE Varchar2 YES NO
PFK VENDID Varchar2 YES NO
PFK SOFTID Varchar2 YES NO
EFFECTDATE Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003934 Identifying VENDOR_SOFTWARE FD_SOFTWARE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIELDPERMS'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK FDID Varchar2 YES NO
PK FDIDSTATE Varchar2 YES NO
PK ATTRID Number YES NO
NATIONAL_VIS Varchar2 NO NO
STATE_VIS Varchar2 NO NO
FD_VIS Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_ALTADDR'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_TOWNSHIP Number(x,y) NO NO
FRW_TOWNSHIPDIR Varchar2 NO NO
FRW_RANGE Number NO NO
FRW_RANGEDIR Varchar2 NO NO
FRW_SECTION Varchar2 NO NO
FRW_SUBSECTION Varchar2 NO NO
FRW_MERIDIAN Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003935 Identifying FIRE_WILDLAND FIRE_ALTADDR 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_BEHAVIOR'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_ELEVATION Number NO NO
FRW_RELATIVEPOSITION Varchar2 NO NO
FRW_ASPECT Varchar2 NO NO
FRW_FLAMELENGTH Number NO NO
FRW_RATEOFSPREAD Number NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003924 Identifying FIRE_WILDLAND FIRE_BEHAVIOR 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_LATLONG'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_LATITUDE Number(x,y) NO NO
FRW_LONGITUDE Number(x,y) NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003925 Identifying FIRE_WILDLAND FIRE_LATLONG 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_PROPERTYMGMT'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_OWNERSHIP Varchar2 NO NO
FRW_UNDETERMINED Number NO NO
FRW_TAXPAYING Number NO NO
FRW_NONTAXPAYING Number NO NO
FRW_CITY Number NO NO
FRW_COUNTY Number NO NO
FRW_STATE Number NO NO
FRW_FEDERAL Number NO NO
FRW_FOREIGN Number NO NO
FRW_MILITARY Number NO NO
FRW_OTHER Number NO NO
FRW_FEDAGENCYCODE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003971 Identifying INCIDENTKEY FIRE_PROPERTYMGMT 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_STRUCTURE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
STR_TYPE Varchar2 NO NO
STR_STATUS Varchar2 NO NO
STR_FLOORSABOVE Number NO NO
STR_FLOORSBELOW Number NO NO
STR_BUILDINGLENGTH Number NO NO
STR_BUILDINGWIDTH Number NO NO
STR_TOTALSQFT Float NO NO
STR_FIREORIGIN Number NO NO
STR_FOBELOWGRADE Varchar2 NO NO
STR_FIRESPREAD Varchar2 NO NO
STR_MINORDAMAGE Number NO NO
STR_SIGDAMAGE Number NO NO
STR_HEAVYDAMAGE Number NO NO
STR_EXTREMEDAMAGE Number NO NO
STR_NOSPREAD Varchar2 NO NO
STR_ITEMTOSPREAD Varchar2 NO NO
STR_TYPETOSPREAD Varchar2 NO NO
STR_DETECTPRESENCE Varchar2 NO NO
STR_DETECTTYPE Varchar2 NO NO
STR_DETECTPOWER Varchar2 NO NO
STR_DETECTOPER Varchar2 NO NO
STR_DETECTEFFECT Varchar2 NO NO
STR_DETECTFAILURE Varchar2 NO NO
STR_AESPRESENCE Varchar2 NO NO
STR_AESTYPE Varchar2 NO NO
STR_NUMSPRINKLERS Number NO NO
STR_AESOPERATION Varchar2 NO NO
STR_AESFAILURE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003926 Identifying INCIDENTKEY FIRE_STRUCTURE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_WEATHER'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_WEATHERTYPE Varchar2 NO NO
FRW_WINDDIRECTION Varchar2 NO NO
FRW_WINDSPEED Number NO NO
FRW_AIRTEMP Number NO NO
FRW_RELATIVEHUMIDITY Number NO NO
FRW_FUELMOISTURE Number NO NO
FRW_DANGERRATING Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003927 Identifying FIRE_WILDLAND FIRE_WEATHER 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIRE_WILDLAND'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FRW_AREATYPE Varchar2 NO NO
FRW_FIRECAUSE Varchar2 NO NO
FRW_HEATSOURCE Varchar2 NO NO
FRW_MOBILEPROPTYPE Varchar2 NO NO
FRW_EQUIPMENTINV Varchar2 NO NO
FRW_NFDRSSTATION Varchar2 NO NO
FRW_NUMBUILDINGS Number NO NO
FRW_NUMTHREATENED Number NO NO
FRW_TOTALACRES Float NO NO
FRW_PRIMARYCROP1 Varchar2 NO NO
FRW_PRIMARYCROP2 Varchar2 NO NO
FRW_PRIMARYCROP3 Varchar2 NO NO
FRW_FUELMODEL Varchar2 NO NO
FRW_PERSONRESPONSIBLE Varchar2 NO NO
FRW_GENDER Varchar2 NO NO
FRW_AGE Number NO NO
FRW_ACTIVITY Varchar2 NO NO
FRW_ROWFEET Number NO NO
FRW_ROWTYPE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003935 Identifying FIRE_WILDLAND FIRE_ALTADDR 1:N
SYS_C003924 Identifying FIRE_WILDLAND FIRE_BEHAVIOR 1:N
SYS_C003925 Identifying FIRE_WILDLAND FIRE_LATLONG 1:N
SYS_C003927 Identifying FIRE_WILDLAND FIRE_WEATHER 1:N
SYS_C003928 Identifying INCIDENTKEY FIRE_WILDLAND 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'FIX_41'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INCIDENTID Number NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'GROUP_FLATFILE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK USERGROUPID Number YES NO
PATH Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003968 Identifying GROUPS GROUP_FLATFILE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'GROUP_VERSIONS'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
USERGROUPID Number NO NO
VERSION Varchar2 NO NO
PATH Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'GROUPS'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK USERGROUPID Number YES NO
USERSTATE Varchar2 NO NO
USERFDID Varchar2 NO NO
USERGROUPPARENTID Number YES NO
USERGROUPDESC Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003942 Identifying GROUPS APPACTION 1:N
SYS_C003943 Identifying GROUPS APPRULE 1:N
SYS_C003946 Identifying GROUPS ATTRIBUTE 1:N
SYS_C003949 Identifying GROUPS ATTR_CODE 1:N
SYS_C003941 Identifying GROUPS CHEMICAL 1:N
SYS_C003929 Non-identifying GROUPS CODECATEGORY 1:N
SYS_C003931 Identifying GROUPS EVENTMESSAGE 1:N
SYS_C003968 Identifying GROUPS GROUP_FLATFILE 1:N
SYS_C003955 Identifying GROUPS IN_TEMPLATEHEADER 1:N
SYS_C003957 Identifying GROUPS NFIRSTRANSACTION 1:N
SYS_C003958 Non-identifying GROUPS NFIRSUSER 1:N
SYS_C003959 Identifying GROUPS SPECIAL_STUDY 1:N
SYS_C003964 Identifying GROUPS USERCOMPRQMTXREF 1:N
SYS_C003967 Identifying GROUPS WINDOW 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_ADDRESS'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
IN_CENSUSTRACT Varchar2 NO NO
IN_LOCATIONTYPE Varchar2 NO NO
IN_NUMORMILE Varchar2 NO NO
IN_PREFIX Varchar2 NO NO
IN_STREETHIGHWAY Varchar2 NO NO
IN_STREETTYPE Varchar2 NO NO
IN_SUFFIX Varchar2 NO NO
IN_APT Varchar2 NO NO
IN_CITY Varchar2 NO NO
IN_STATE Varchar2 NO NO
IN_ZIP Varchar2 NO NO
IN_DIRECTIONS Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003918 Identifying IN_BASIC IN_ADDRESS 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_APPARATUS'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK AP_SEQ Number YES NO
APID Varchar2 NO NO
AP_TYPE Varchar2 NO NO
AP_DISPATCHDATE Date NO NO
AP_ARRIVALDATE Date NO NO
AP_CLEARDATE Date NO NO
AP_NUMPEOPLE Number NO NO
AP_USE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003970 Identifying INCIDENTKEY IN_APPARATUS 1:N
SYS_C003952 Identifying IN_APPARATUS IN_PERSONNEL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_ARSON'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
AR_CASESTATUS Varchar2 NO NO
AR_IGNITIONAVAIL Varchar2 NO NO
AR_ENTRYMETHOD Varchar2 NO NO
AR_EXTENTOFFIREINV Varchar2 NO NO
AR_CONTAINER Varchar2 NO NO
AR_DELAYDEVICE Varchar2 NO NO
AR_FUEL Varchar2 NO NO
AR_PROPERTYOWNERSHIP Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003919 Identifying INCIDENTKEY IN_ARSON 1:N
SYS_C003920 Identifying IN_ARSON IN_ARSONAGENCYXREF 1:N
SYS_C003921 Identifying IN_ARSON IN_ARSONJUVENILE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_ARSONAGENCYXREF'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
AR_AGENCYNAME Varchar2 NO NO
AR_STREETNUMBER Varchar2 NO NO
AR_STREETPREFIX Varchar2 NO NO
AR_STREET Varchar2 NO NO
AR_STREETTYPE Varchar2 NO NO
AR_APT Varchar2 NO NO
AR_STREETSUFFIX Varchar2 NO NO
AR_CITY Varchar2 NO NO
AR_STATE Varchar2 NO NO
AR_ZIP Varchar2 NO NO
AR_PHONE Varchar2 NO NO
AR_CASENUMBER Varchar2 NO NO
AR_ORI Varchar2 NO NO
AR_FID Varchar2 NO NO
AR_FDID Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003920 Identifying IN_ARSON IN_ARSONAGENCYXREF 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_ARSONJUVENILE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK AR_SUBJECT Number YES NO
AR_AGE Number NO NO
AR_GENDER Varchar2 NO NO
AR_RACE Varchar2 NO NO
AR_ETHNICITY Varchar2 NO NO
AR_FAMILYTYPE Varchar2 NO NO
AR_DISPOSITION Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003921 Identifying IN_ARSON IN_ARSONJUVENILE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_AUTHORITY'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK AUTHTYPE Varchar2 YES NO
IN_AUTHPERSONNELID Varchar2 NO NO
IN_AUTHLNAME Varchar2 NO NO
IN_AUTHFNAME Varchar2 NO NO
IN_AUTHMI Varchar2 NO NO
IN_AUTHRANK Varchar2 NO NO
IN_AUTHASSIGNMENT Varchar2 NO NO
IN_AUTHDATE Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003922 Identifying IN_BASIC IN_AUTHORITY 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_BASIC'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
IN_TYPE Varchar2 NO NO
IN_ADDRONWILDLAND Varchar2 NO NO
IN_MUTUALAIDFLAG Varchar2 NO NO
IN_ALARMDATE Date NO NO
IN_ARRIVALDATE Date NO NO
IN_CONTROLLEDDATE Date NO NO
IN_LASTUNITCLEAREDDATE Date NO NO
IN_SHIFT Varchar2 NO NO
IN_ALARMS Varchar2 NO NO
IN_DISTRICT Varchar2 NO NO
IN_RESOURCEFORMUSED Varchar2 NO NO
IN_APPARSUPP Number NO NO
IN_APPAREMS Number NO NO
IN_APPAROTHER Number NO NO
IN_PERSSUPP Number NO NO
IN_PERSEMS Number NO NO
IN_PERSOTHER Number NO NO
IN_INCMUTAID Varchar2 NO NO
IN_LOSSPROPERTY Number NO NO
IN_LOSSOTHER Number NO NO
IN_LOSSTOTAL Number NO NO
IN_VALUEPROPERTY Number NO NO
IN_VALUEOTHER Number NO NO
IN_FATALFS Number NO NO
IN_FATALOTHER Number NO NO
IN_NONFATALFS Number NO NO
IN_NONFATALOTHER Number NO NO
IN_DETECTOR Varchar2 NO NO
IN_HAZMATRELEASED Varchar2 NO NO
IN_MIXEDUSE Varchar2 NO NO
IN_PROPERTYUSE Varchar2 NO NO
IN_FIRECAUSE Varchar2 NO NO
IN_FATALEMS Number NO NO
IN_NONFATALEMS Number NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003923 Identifying INCIDENTKEY IN_BASIC 1:N
SYS_C003918 Identifying IN_BASIC IN_ADDRESS 1:N
SYS_C003922 Identifying IN_BASIC IN_AUTHORITY 1:N
SYS_C003916 Identifying IN_BASIC IN_MUTUALAID 1:N
SYS_C003917 Identifying IN_BASIC IN_OWNERPERSON 1:N
SYS_C003953 Identifying IN_BASIC IN_SPECIALSTUDY 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_BASIC41'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
IN_METHODOFALARM Varchar2 NO NO
IN_METHODOFEXTINGUISH Varchar2 NO NO
IN_CONSTRUCTIONTYPE Varchar2 NO NO
IN_EXTENTSMOKEDAMAGE Varchar2 NO NO
IN_TYPEMATERIALGENSMOKE Varchar2 NO NO
IN_FORMMATERIALGENSMOKE Varchar2 NO NO
IN_AVENUEOFSMOKE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003912 Identifying INCIDENTKEY IN_BASIC41 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_FIRE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
FR_NUMBUILDINGS Number NO NO
FR_NUMRESIDENTIAL Number NO NO
FR_NOTRESIDENTIAL Varchar2 NO NO
FR_ACRESBURNED Number NO NO
FR_LESSTHANONEACRE Varchar2 NO NO
FR_AREAOFORIGIN Varchar2 NO NO
FR_HEATSOURCE Varchar2 NO NO
FR_ITEMFIRSTIGNITED Varchar2 NO NO
FR_CONFINEDTOORIGIN Varchar2 NO NO
FR_TYPEOFMATERIAL Varchar2 NO NO
FR_CAUSEOFIGNITION Varchar2 NO NO
FR_AGEOFPERSON Number NO NO
FR_SEXOFPERSON Varchar2 NO NO
FR_EQUIPMENTINV Varchar2 NO NO
FR_MOBILEPROPINV Varchar2 NO NO
FR_PREFIREPLAN Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003913 Identifying INCIDENTKEY IN_FIRE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_FIRECAUSE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK INCIDENTID Number YES NO
IN_PCCCODE Varchar2 NO NO
IN_CAUSECODE Varchar2 NO NO
IN_ARSONCODE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_FIRECAUSE_RECODE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK INCIDENTID Number YES NO
IN_PCCCODE Varchar2 NO NO
IN_CAUSECODE Varchar2 NO NO
IN_ARSONCODE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_HAZMAT'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
HM_RELATIONTOSTRUCTURE Varchar2 NO NO
HM_FLOOROFRELEASE Number NO NO
HM_FLOORBELOWGRADE Varchar2 NO NO
HM_POPULATIONDENSITY Varchar2 NO NO
HM_AREAAFFECTED Number NO NO
HM_AREAAFFECTEDUNITS Varchar2 NO NO
HM_AREAEVACUATED Number NO NO
HM_AREAEVACUATEDUNITS Varchar2 NO NO
HM_PEOPLEEVACUATED Number NO NO
HM_BUILDINGSEVACUATED Number NO NO
HM_RELEASEFIRST Varchar2 NO NO
HM_CAUSEOFRELEASE Varchar2 NO NO
HM_EQUIPINV Varchar2 NO NO
HM_DISPOSITION Varchar2 NO NO
HM_CIVILIANDEATHS Number NO NO
HM_CIVILIANINJURIES Number NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003914 Identifying INCIDENTKEY IN_HAZMAT 1:N
SYS_C003915 Identifying IN_HAZMAT IN_HMCHEMICAL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_HMCHEMICAL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK HM_NUM Number YES NO
HM_DOTID Varchar2 NO NO
HM_HAZARDCLASS Varchar2 NO NO
HM_CAS_REGISTRATION Varchar2 NO NO
HM_CHEMICALNAME Varchar2 NO NO
HM_CHEMICALID Varchar2 NO NO
HM_CONTAINERTYPE Varchar2 NO NO
HM_CONTAINERCAPACITY Float NO NO
HM_CONTAINERUNITS Varchar2 NO NO
HM_RELEASED Float NO NO
HM_RELEASEDUNITS Varchar2 NO NO
HM_STATEWHENRELEASED Varchar2 NO NO
HM_RELINTO Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003915 Identifying IN_HAZMAT IN_HMCHEMICAL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_MULTIPLECODE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK ATTRID Number YES NO
PK ATTRMAININDEX Number YES NO
PK ATTRSUBINDEX Number YES NO
PK ATTRSEQ Number YES NO
CODEVALUE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003969 Identifying INCIDENTKEY IN_MULTIPLECODE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_MUTUALAID'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
IN_ASSISTFDID Varchar2 NO NO
IN_ASSISTFDIDSTATE Varchar2 NO NO
IN_ASSISTINCIDENT Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003916 Identifying IN_BASIC IN_MUTUALAID 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_OWNERPERSON'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK ADDRTYPE Varchar2 YES NO
PK ADDRSEQ Number YES NO
OP_NAMEPREFIX Varchar2 NO NO
OP_FNAME Varchar2 NO NO
OP_MI Varchar2 NO NO
OP_LNAME Varchar2 NO NO
OP_NAMESUFFIX Varchar2 NO NO
OP_BUSINESSNAME Varchar2 NO NO
OP_PHONE Varchar2 NO NO
OP_NUMORMILE Varchar2 NO NO
OP_PREFIX Varchar2 NO NO
OP_STREETHIGHWAY Varchar2 NO NO
OP_STREETTYPE Varchar2 NO NO
OP_SUFFIX Varchar2 NO NO
OP_POBOX Varchar2 NO NO
OP_APT Varchar2 NO NO
OP_CITY Varchar2 NO NO
OP_STATE Varchar2 NO NO
OP_ZIP Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003917 Identifying IN_BASIC IN_OWNERPERSON 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_PERSONNEL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PFK AP_SEQ Number YES NO
PK PR_SEQ Number YES NO
PR_PERSID Varchar2 NO NO
PR_LNAME Varchar2 NO NO
PR_FNAME Varchar2 NO NO
PR_MI Varchar2 NO NO
PR_RANK Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003952 Identifying IN_APPARATUS IN_PERSONNEL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_SPECIALSTUDY'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK SS_SEQ Number YES NO
PK SPECIALSTUDYID Number YES NO
SS_CODEVALUE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003953 Identifying IN_BASIC IN_SPECIALSTUDY 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_TEMPLATEDETAIL'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK TEMPLATEID Number YES NO
PFK USERGROUPID Number YES NO
PK TEMPLATESEQ Number YES NO
TEMPLATETRANSID Number NO NO
TEMPLATEDETAIL Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003954 Identifying IN_TEMPLATEHEADER IN_TEMPLATEDETAIL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'IN_TEMPLATEHEADER'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK TEMPLATEID Number YES NO
PFK USERGROUPID Number YES NO
TEMPLATENAME Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003955 Identifying GROUPS IN_TEMPLATEHEADER 1:N
SYS_C003954 Identifying IN_TEMPLATEHEADER IN_TEMPLATEDETAIL 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'INC_ACTION'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK INCIDENTID Number YES NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'INCIDENTKEY'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK INCIDENTID Number YES NO
IN_RELEASE Varchar2 NO NO
IN_STATUS Varchar2 NO NO
FDID Varchar2 NO NO
FDIDSTATE Varchar2 NO NO
IN_DATE Date NO NO
IN_NUM Varchar2 NO NO
IN_EXPOSURE Number NO NO
IN_STATION Varchar2 NO NO
IN_NFIRSVERSION Varchar2 NO NO
IN_VENDORID Varchar2 NO NO
IN_SOFTWAREID Varchar2 NO NO
IN_LASTUPDATED Date NO NO
IN_LASTUPDATEDBY Varchar2 NO NO
IN_CREATED Date NO NO
IN_CREATEDBY Varchar2 NO NO
IN_NFIRSLOADVERSION Varchar2 NO NO
IN_LASTEXPORTED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003938 Identifying INCIDENTKEY CAS_CIVILIAN 1:N
SYS_C003939 Identifying INCIDENTKEY CAS_EMS 1:N
SYS_C003940 Identifying INCIDENTKEY CAS_FIRESERVICE 1:N
SYS_C003930 Identifying INCIDENTKEY EQUIP_INVOLVED 1:N
SYS_C003971 Identifying INCIDENTKEY FIRE_PROPERTYMGMT 1:N
SYS_C003926 Identifying INCIDENTKEY FIRE_STRUCTURE 1:N
SYS_C003928 Identifying INCIDENTKEY FIRE_WILDLAND 1:N
SYS_C003970 Identifying INCIDENTKEY IN_APPARATUS 1:N
SYS_C003919 Identifying INCIDENTKEY IN_ARSON 1:N
SYS_C003923 Identifying INCIDENTKEY IN_BASIC 1:N
SYS_C003912 Identifying INCIDENTKEY IN_BASIC41 1:N
SYS_C003913 Identifying INCIDENTKEY IN_FIRE 1:N
SYS_C003914 Identifying INCIDENTKEY IN_HAZMAT 1:N
SYS_C003969 Identifying INCIDENTKEY IN_MULTIPLECODE 1:N
SYS_C003956 Identifying INCIDENTKEY MOBILE_PROP 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'INSTANCE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INSTANCEID Number NO NO
REPORT_SHELL Number NO NO
DESCRIPTION Varchar2 NO NO
QUEUE_TIME Float NO NO
START_TIME Float NO NO
END_TIME Float NO NO
STATUS Varchar2 NO NO
USERGROUPID_CREATOR Number NO NO
USERNAME_CREATOR Varchar2 NO NO
USERSTATE_CREATOR Varchar2 NO NO
SAVE Varchar2 NO NO
VISABILITY_CODE Varchar2 NO NO
REMARKS Varchar2 NO NO
OUTPUT_TYPE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'INSTANCE_DETAIL'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INSTANCEID Number NO NO
SEQUENCE Number(x,y) NO NO
LOGICAL_OPERATOR Varchar2 NO NO
ATTRID Number NO NO
RELATIONAL_OPERATOR Varchar2 NO NO
VALUE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'LOOKUP_NEXT_PK'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK TABLENAME Varchar2 YES NO
PK USERGROUPID Number YES NO
NEXTPRIMARYKEY Number NO NO
MAXKEYVALUE Number NO NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'MOBILE_PROP'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK INCIDENTID Number YES NO
PK MP_RECTYPE Varchar2 YES NO
MP_TYPE Varchar2 NO NO
MP_MAKE Varchar2 NO NO
MP_MODEL Varchar2 NO NO
MP_YEAR Number(x,y) NO NO
MP_VIN Varchar2 NO NO
MP_LICENSEPLATE Varchar2 NO NO
MP_STATE Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003956 Identifying INCIDENTKEY MOBILE_PROP 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'NFIC_REGION'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK REGIONSTATE Varchar2 YES NO
REGIONID Varchar2 YES NO

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'NFIRSTRANSACTION'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK TRANSID Number YES NO
PFK USERGROUPID Number YES NO
TRANSTYPE Number YES NO
EXTERNALTRANSID Number NO NO
TRANSDESC Varchar2 NO NO
PARENTTRANS Number NO NO
TRANSINDEX Varchar2 NO NO
EMPTYASBLANK Varchar2 NO NO
TRANSACTIONSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003957 Identifying GROUPS NFIRSTRANSACTION 1:N
SYS_C003961 Identifying NFIRSTRANSACTION TRANSCONVERT 1:N
SYS_C003962 Identifying NFIRSTRANSACTION TRANSDELIMATTR 1:N
SYS_C003963 Identifying NFIRSTRANSACTION TRANSFIXEDATTR 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'NFIRSUSER'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK USERNAME Varchar2 YES NO
PK USERSTATE Varchar2 YES NO
USERPASSWORD Varchar2 NO NO
USERSTATUS Varchar2 NO NO
FK USERGROUPID Number NO NO
USERLNAME Varchar2 NO NO
USERFNAME Varchar2 NO NO
USERMI Varchar2 NO NO
USEREMAIL Varchar2 NO NO
USERPHONE Varchar2 NO NO
USERNUMBADLOGIN Number NO NO
USERLASTLOGINDATE Date NO NO
USERLASTPWDATE Date NO NO
USERMUSTCHANGEPW Varchar2 YES NO
USERPERMISSIONS Varchar2 NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003958 Non-identifying GROUPS NFIRSUSER 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'RESULT_STAGE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INSTANCEID Number NO NO
ROW_NUM Number NO NO
DELIMITED_STRING Varchar2 NO NO
ROW_TYPE Number NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'RESULTS'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
INSTANCEID Number(x,y) NO NO
ROW_NUM Number(x,y) NO NO
ROW_TYPE Varchar2 NO NO
DELIMITED_STRING Varchar2 NO NO
DELIMETER Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'SPECIAL_STUDY'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK SS_ID Number YES NO
PFK USERGROUPID Number YES NO
SS_DESCRIPTION Varchar2 NO NO
SS_STARTDATE Date NO NO
SS_STOPDATE Date NO NO
SS_CODEGENERICLENGTH Number NO NO
SS_STATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003959 Identifying GROUPS SPECIAL_STUDY 1:N
SYS_C003960 Identifying SPECIAL_STUDY SS_CODE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'SS_CODE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK SS_ID Number YES NO
PK SS_CODE Varchar2 YES NO
PFK USERGROUPID Number YES NO
SS_PARENTCODEVALUE Varchar2 NO NO
SS_DECODE Varchar2 NO NO
SS_CODESTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003960 Identifying SPECIAL_STUDY SS_CODE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'STAGINGAREA'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK INCIDENTID Number YES NO
PK RPTID Number YES NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'TEMPLATE'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
TEMPLATEID Number(x,y) NO NO
DESCRIPTION Varchar2 NO NO
USERGROUPID_CREATOR Number NO NO
LAST_UPDATE Date NO NO
STATIC Varchar2 NO NO
USERNAME_CREATOR Varchar2 NO NO
USERSTATE_CREATOR Varchar2 NO NO
VISABILITY_CODE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'TEMPLATE_DETAIL'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
TEMPLATEID Number NO NO
SEQUENCE Number(x,y) NO NO
STATIC Varchar2 NO NO
LOGICAL_OPERATOR Varchar2 NO NO
ATTRID Number(x,y) NO NO
RELATIONAL_OPERATOR Varchar2 NO NO
VALUE Varchar2 NO NO

 User-defined variables
Name Value
Owner NFIRS50V3
Tablespace for Primary key
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'TRANSCONVERT'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK TRANSID/TRANSIDOLD Number YES NO
PFK USERGROUPID Number YES NO
TRANSIDNEW Number NO NO
STATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003961 Identifying NFIRSTRANSACTION TRANSCONVERT 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'TRANSDELIMATTR'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK TRANSID Number YES NO
PFK USERGROUPID Number YES NO
PK TRANSSEQ Number YES NO
PK SUBTRANSEQ Number YES NO
ATTRID Number YES NO
KEYATTR Varchar2 NO NO
SUBTRANSSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003962 Identifying NFIRSTRANSACTION TRANSDELIMATTR 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'TRANSFIXEDATTR'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK TRANSID Number YES NO
PFK USERGROUPID Number YES NO
PK TRANSSEQ Number YES NO
ATTRID Number NO NO
KEYATTR Varchar2 NO NO
STARTPOS Number NO NO
STOPPOS Number NO NO
SUBTRANSSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003963 Identifying NFIRSTRANSACTION TRANSFIXEDATTR 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'USERCOMPRQMTXREF'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK ATTRID Number YES NO
PFK USERGROUPID Number YES NO
REQUIREMENTID Number NO NO
COMPREQSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003964 Identifying GROUPS USERCOMPRQMTXREF 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'USERCOMPSECXREF'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK ATTRID Number YES NO
PFK USERGROUPID Number YES NO
SECURITYID Number NO NO
COMPSECSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003965 Identifying ATTRIBUTE USERCOMPSECXREF 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'VENDOR'

 General info
Entity type: independent

 Attributes
Key Attribute/role name Data type Not null Unique
PK VENDID Varchar2 YES NO
VENDNAME Varchar2 NO NO
VENDPASSWORD Varchar2 YES NO
VENDADDR1 Varchar2 NO NO
VENDADDR2 Varchar2 NO NO
VENDCITY Varchar2 NO NO
VENDST Varchar2 NO NO
VENDZIP Varchar2 NO NO
VENDPHONE Varchar2 NO NO
VENDFAX Varchar2 NO NO
VENDWWW Varchar2 NO NO
VENDEMAIL Varchar2 NO NO
VENDADDRVERDATE Date NO NO
VENDSTATUS Varchar2 NO NO
VENDLASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003966 Identifying VENDOR VENDOR_SOFTWARE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'VENDOR_SOFTWARE'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PFK VENDID Varchar2 YES NO
PK SOFTID Varchar2 YES NO
SOFTWARE_NAME Varchar2 NO NO
SOFTWARE_VERSION Varchar2 NO NO
NFIRSVERSION Varchar2 NO NO
CERTIFICATIONDATE Date NO NO
COMMENTS Varchar2 NO NO
STATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003966 Identifying VENDOR VENDOR_SOFTWARE 1:N
SYS_C003934 Identifying VENDOR_SOFTWARE FD_SOFTWARE 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table


Entity 'WINDOW'

 General info
Entity type: dependent

 Attributes
Key Attribute/role name Data type Not null Unique
PK WINDOWID Number YES NO
PFK USERGROUPID Number YES NO
WINDOWDESC Varchar2 NO NO
WINDOWSTATUS Varchar2 NO NO
LASTUPDATED Date NO NO

 Relationships
Relationship name Type Parent entity Child entity Card.
SYS_C003967 Identifying GROUPS WINDOW 1:N

 User-defined variables
Name Value
Owner NFIRS50
Tablespace for Primary key NFIRS_DATA
Primary Key Deferrable No
Primary Key Initially Deferred No
Tablespace for Table