Entity Definition Report
Run by: CASEOWNER
Run on: February 13, 2007 10:47 AM
Total Pages: 21
Total Entities: 19
Parameters
Application: SOSS
Entities: %
ER Diagram: %
Include Entity Notes? Y
Include Attribute Descriptions? Y
Include Attribute Notes? Y
Include Attribute Values? Y
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 1 of 21
Application: SOSS
ACTIVITY SAFETY RATING CODE Short Name: ASRC
Plural: ACTIVITY SAFETY RATING CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Holds activity safety rating codes.
Attributes:
Name Domain Opt Format Length
* ACTIVITY SAFETY RATING CODE   N VARCHAR2 1
Codes for activity safety ratings.
DESCRIPTION   N VARCHAR2 120
Description of the activity safety rating.
EFFECTIVE DATE   N DATE  
The effective date of the activity safety rating.
EXPIRY DATE   N DATE  
The expiry date for the activity safety rating.
UPDATE TIMESTAMP   N DATE  
The date/time that the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE hold activity safety ratings for one or more WORK CALL RATING XF
* = Relationships in primary unique identifier.
Unique Identifiers:
ASR Primary? Y
ACTIVITY SAFETY RATING CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 2 of 21
Application: SOSS
CALL FREQUENCY Short Name: CF
Plural: CALL FREQUENCY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table maps codes to a specific numeric value.
Attributes:
Name Domain Opt Format Length
CALL FREQUENCY VALUE   N NUMBER  
The numeric value of the code.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds call frequency data for one or more SIGN OUT DAILY TRACKING HISTORY
MAY BE shows call frequency data for one or more SIGN OUT DAILY TRACKING
* MUST BE holds call frequency value for one and only one CALL FREQUENCY CODE
* = Relationships in primary unique identifier.
Unique Identifiers:
CF Primary? Y
MUST BE holds call frequency value for one and only one CALL FREQUENCY CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 3 of 21
Application: SOSS
CALL FREQUENCY CODE Short Name: CFC
Plural: CALL FREQUENCY CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Holds call frequency codes.
Attributes:
Name Domain Opt Format Length
* CALL FREQUENCY CODE   N VARCHAR2 5
Codes for call frequencies.
DESCRIPTION   N VARCHAR2 120
The description of the call frequency.
EFFECTIVE DATE   N DATE  
The effective date for the call frequency code.
EXPIRY DATE   N DATE  
The expiry date for the call frequency code.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds call frequencies for one or more WORK CALL RATING XF
MUST BE holds call frequency code for one and only one CALL FREQUENCY
* = Relationships in primary unique identifier.
Unique Identifiers:
CFC Primary? Y
CALL FREQUENCY CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 4 of 21
Application: SOSS
ENTRY TYPE CODE Short Name: ETC
Plural: ENTRY TYPE CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This code table represents the values available for sign-out entry types.
Attributes:
Name Domain Opt Format Length
* ENTRY TYPE CODE   N VARCHAR2 10
Codes representing the available values for sign-out entry types.
DESCRIPTION   N VARCHAR2 120
The description of the code.
EFFECTIVE DATE   N DATE  
The effective date of the code.
EXPIRY DATE   N DATE  
The expiry date of the code.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds entry types for one or more SIGN OUT DAILY TRACKING
MAY BE holds entry types one or more SIGN OUT DAILY TRACKING HISTORY
* = Relationships in primary unique identifier.
Unique Identifiers:
ETC Primary? Y
ENTRY TYPE CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 5 of 21
Application: SOSS
OFFICE EMPLOYEE Short Name: EMP
Plural: OFFICE EMPLOYEE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table determines which employees belong to which office and any preferences for that employee.
Attributes:
Name Domain Opt Format Length
* EMPLOYEE USERID   N VARCHAR2 64
The unique userid for the employee.
RADIO CALL SIGN   N VARCHAR2 8
The radio call sign for the employee.
PROGRAM DESCRIPTION   N VARCHAR2 250
The program the employee belongs to.
FIRST NAME   N VARCHAR2 40
LAST NAME   N VARCHAR2 40
MIDDLE INITIAL   Y VARCHAR2 1
TELEPHONE NUMBER   Y VARCHAR2 10
ENTRY USERID   N VARCHAR2 64
The user who created the record.
ENTRY TIMESTAMP   N DATE  
The date/time the record was created.
UPDATE USERID   N VARCHAR2 64
The user who last updated the record.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
ACTIVE INDICATOR   N VARCHAR2 1
Determines whether the record is active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds who signed-out one or more RESOURCE DAILY TRACKING
MAY BE holds who signed-out one or more RESOURCE DAILY TRACKING HISTORY
MAY BE holds who signed-out one or more SIGN OUT DAILY TRACKING
MAY BE holds who signed-out one or more SIGN OUT DAILY TRACKING HISTORY
MAY BE shows signed-out employee one or more SIGN OUT DAILY TRACKING
MAY BE shows signed-out employee one or more SIGN OUT DAILY TRACKING HISTORY
MUST BE hold employees for one and only one OFFICE PREFERENCE
* = Relationships in primary unique identifier.
Unique Identifiers:
EMP Primary? Y
EMPLOYEE USERID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 6 of 21
Application: SOSS
OFFICE PREFERENCE Short Name: OP
Plural: OFFICE PREFERENCE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The table holds the offices and their preferences that are available to the application.
Attributes:
Name Domain Opt Format Length
OFFICE DESCRIPTION   N VARCHAR2 100
The description of the office, i.e., South Island Forest District.
CHECKIN REQUIRED INDICATOR   N VARCHAR2 1
An Y/N indicator which identifies if the office default for check-in required is Yes or No.
ENTRY USERID   N VARCHAR2 64
The user who created the record.
ENTRY TIMESTAMP   N DATE  
The time the record was created.
UPDATE USERID   N VARCHAR2 64
The user who last updated the record.
UPDATE TIMESTAMP   N DATE  
The time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE shows office for one or more OFFICE EMPLOYEE
MAY BE shows office for one or more OFFICE RESOURCE
MAY BE shows office for one or more OFFICE RESOURCE CATEGORY
* MUST BE shows preferences for one and only one ORG UNIT
* = Relationships in primary unique identifier.
Unique Identifiers:
OFF Primary? Y
MUST BE shows preferences for one and only one ORG UNIT
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 7 of 21
Application: SOSS
OFFICE RESOURCE Short Name: RES
Plural: OFFICE RESOURCE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table holds the resources and their associated information available for sign-out.
Attributes:
Name Domain Opt Format Length
* RESOURCE ID   N NUMBER 10
A unique identifier for the resource record.
IDENTIFIER   N VARCHAR2 100
Holds a value which identifies the resource. i.e. VE65421-2000.
DESCRIPTION   N VARCHAR2 400
Holds a description of the resource.
CONTACT NAME   N VARCHAR2 100
Holds the contact name for the resource.
ENTRY USERID   N VARCHAR2 64
The user who intially created the resource record.
ENTRY TIMESTAMP   N DATE  
The date/time the resource entry was created.
UPDATE USERID   N VARCHAR2 64
The user who last updated the record.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds resource for one or more RESOURCE DAILY TRACKING
MAY BE holds resource for one or more RESOURCE DAILY TRACKING HISTORY
MUST BE hold resources for one and only one OFFICE PREFERENCE
MUST BE shows resource priority codes one and only one RESOURCE PRIORITY CODE
MUST BE shows resource status codes for one and only one RESOURCE STATUS CODE
MUST BE shows resources for one and only one OFFICE RESOURCE CATEGORY
* = Relationships in primary unique identifier.
Unique Identifiers:
RES Primary? Y
RESOURCE ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 8 of 21
Application: SOSS
OFFICE RESOURCE CATEGORY Short Name: CAT
Plural: OFFICE RESOURCE CATEGORY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table identifies ten categories for each office that they can place resources into.
Attributes:
Name Domain Opt Format Length
* CATEGORY ID   N NUMBER  
Unique identifier for the category.
NAME   N VARCHAR2 500
Name of the category.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE show category for one or more OFFICE RESOURCE
MUST BE holds categories for one and only one OFFICE PREFERENCE
* = Relationships in primary unique identifier.
Unique Identifiers:
CAT Primary? Y
CATEGORY ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 9 of 21
Application: SOSS
ORG UNIT Short Name: OU
Plural: ORG UNIT
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Ministry maintained table that contains all org units.
Attributes:
Name Domain Opt Format Length
* ORG UNIT NO   N NUMBER 10
The number of the org unit.
ORG UNIT NAME   N VARCHAR2 100
The name of the org unit.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE shows entries for one or more SIGN OUT DAILY TRACKING
MAY BE shows entries for one or more SIGN OUT DAILY TRACKING HISTORY
MAY BE shows org unit for one and only one OFFICE PREFERENCE
MAY BE shows org unit for one or more SAFETY JURISDICTION
MAY BE shows resource entries for one or more RESOURCE DAILY TRACKING
MAY BE shows resource entries for one or more RESOURCE DAILY TRACKING HISTORY
MAY BE shows suggested activity times one or more WORK CALL RATING XF
* = Relationships in primary unique identifier.
Unique Identifiers:
OU Primary? Y
ORG UNIT NO
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 10 of 21
Application: SOSS
RESOURCE DAILY TRACKING Short Name: RDT
Plural: RESOURCE DAILY TRACKING
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table holds data the identifies which resources are signed-out and when.
Attributes:
Name Domain Opt Format Length
* RESOURCE DAILY TRACKING ID   N NUMBER 10
A unique id for the resource sign-out.
SIGN OUT TIMESTAMP   N DATE  
The date/time the resource was signed out.
ESTIMATED SIGNIN TIMESTAMP   N DATE  
The data/time the resource is expected to be returned.
ACTUAL SIGNIN TIMESTAMP   Y DATE  
The date/time the resource was actually returned.
LOCATION DESCRIPTION   Y VARCHAR2 480
A freeform description identifying where the resource is and the purpose of the sign-out.
ENTRY USERID   N VARCHAR2 64
The user who initially signed-out the entry.
ENTRY TIMESTAMP   N DATE  
The date/time the entry was entered.
UPDATE USERID   N VARCHAR2 64
The user who last updated the sign-out.
UPDATE TIMESTAMP   N DATE  
The last date/time the resource entry was updated.
ACTIVE INDICATOR   N VARCHAR2 1
A indicator determing whether the record is active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE shows org unit for one and only one ORG UNIT
MUST BE shows resource entry for one and only one OFFICE RESOURCE
MUST BE shows signed-out resource for one and only one OFFICE EMPLOYEE
* = Relationships in primary unique identifier.
Unique Identifiers:
RDT Primary? Y
RESOURCE DAILY TRACKING ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 11 of 21
Application: SOSS
RESOURCE DAILY TRACKING HISTORY Short Name: RDTH
Plural: RESOURCE DAILY TRACKING HISTORY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table holds historic data for resource sign-out entries. These entries have either been closed (contain an actual sign-out date/time) or have been deleted.
Attributes:
Name Domain Opt Format Length
* RESOURCE DAILY TRACKING HISTORY ID
   N NUMBER 10
SIGN OUT TIMESTAMP   N DATE  
History: The date/time the resource was signed-out.
ESTIMATED SIGNIN TIMESTAMP   N DATE  
History: The estimated date/time the resource was expected to be returned.
ACTUAL SIGNIN TIMESTAMP   Y DATE  
History: The actual date/time the resource was returned.
LOCATION DESCRIPTION   N VARCHAR2 480
History: The location/purpose of the resources sign-out.
ENTRY USERID   N VARCHAR2 64
History: The user who intially entered the sign-out.
ENTRY TIMESTAMP   N DATE  
History: The date/time the entry was created.
UPDATE USERID   N VARCHAR2 64
History: The user who last updated the record.
UPDATE TIMESTAMP   N DATE  
History: The date/time the record was last updated.
ACTIVE INDICATOR   N VARCHAR2 1
History: Determines whether the record was active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE shows org unit for one and only one ORG UNIT
MUST BE shows resource entry for one and only one OFFICE RESOURCE
MUST BE shows signed-out resource for one and only one OFFICE EMPLOYEE
* = Relationships in primary unique identifier.
Unique Identifiers:
RDTH Primary? Y
RESOURCE DAILY TRACKING HISTORY ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 12 of 21
Application: SOSS
RESOURCE PRIORITY CODE Short Name: RPC
Plural: RESOURCE PRIORITY CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This code table represents the codes available for resource priorities.
Attributes:
Name Domain Opt Format Length
* RESOURCE PRIORITY CODE   N VARCHAR2 10
The code representing a resource priority.
DESCRIPTION   N VARCHAR2 120
The description of the resource priority.
EFFECTIVE DATE   N DATE  
The effective date of the code.
EXPIRY DATE   N DATE  
The expiry date of the code.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds resource priorities for one or more OFFICE RESOURCE
* = Relationships in primary unique identifier.
Unique Identifiers:
RPC Primary? Y
RESOURCE PRIORITY CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 13 of 21
Application: SOSS
RESOURCE STATUS CODE Short Name: RSC
Plural: RESOURCE STATUS CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Identifies code values for resource statuses.
Attributes:
Name Domain Opt Format Length
* RESOURCE STATUS CODE   N VARCHAR2 10
Unique code for a resource status.
DESCRIPTION   N VARCHAR2 120
The description of the code.
EFFECTIVE DATE   N DATE  
The effective date of the code.
EXPIRY DATE   N DATE  
The expiry date of the code.
UPDATE TIMESTAMP   N DATE  
The date/time the code was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds resource status codes for one or more OFFICE RESOURCE
* = Relationships in primary unique identifier.
Unique Identifiers:
RSC Primary? Y
RESOURCE STATUS CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 14 of 21
Application: SOSS
SAFETY JURISDICTION Short Name: SJ
Plural: SAFETY JURISDICTION
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
The table relates org units to a city and a specific timezone.
Attributes:
Name Domain Opt Format Length
* CITY   N VARCHAR2 50
The city relating to the org unit and time zone.
TIMEZONE   N VARCHAR2 40
The timezone for the specific city.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
* MUST BE cities for one and only one ORG UNIT
* = Relationships in primary unique identifier.
Unique Identifiers:
SJ Primary? Y
CITY
MUST BE cities for one and only one ORG UNIT
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 15 of 21
Application: SOSS
SIGN OUT DAILY TRACKING Short Name: SODT
Plural: SIGN OUT DAILY TRACKING
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Holds information on the daily office sign outs of employees to perform MOFR activities. Tracks which employee is signing out when, how long the employee is expected to be away performing the activity, and when the employee is to check in.
Attributes:
Name Domain Opt Format Length
* SIGN OUT DAILY TRACKING ID   N NUMBER 10
Database generated unique identifier for records in the SIGN OUT DAILY TRACKING table.
LAST NAME   N VARCHAR2 40
The last name of the employee being tracked in the Sign Out Security System.
 
FIRST NAME   N VARCHAR2 40
The first name of the employee being tracked in the Sign Out Security System.
MIDDLE INITIAL   Y VARCHAR2 1
Initial of the employees middle name.
SIGN OUT TIMESTAMP   N DATE  
The date/time that the employee has signed out of of the office, this begins the tracking process.
ESTIMATED SIGNIN TIMESTAMP   N DATE  
The date/time when the employee is estimated to sign-in, upon sign-in the employee is deemed safe.
ACTUAL SIGNIN TIMESTAMP   Y DATE  
The actual date/time when the employee signs-in, at this date/time the employee is deemed safe.
CURRENT CHECKIN TIMESTAMP   Y DATE  
The date/time when the employee will call into the office (or some other means of contacting a Safety Officer, i.e., radio) to 'check-in' and communicate that they are safe.
LOCATION DESCRIPTION   Y VARCHAR2 480
The location description of where the employee is.
TRANSPORTATION TYPE   Y VARCHAR2 50
Specifies what type of transportation will be used to reach the out-of-office location.
CHECKIN REQUIRED   N VARCHAR2 1
Specifies if an entry requires a check-in date/time. Entries that do not required check-ins are outings such as vacation, appointments etc.
RADIO CALL SIGN   N VARCHAR2 8
The radio call sign of the employee who is signed-out. MoFR from a30 to pgx025; aircraft: 6 to 8 characters; boats: usually name of boat or whatever the skipper answers too.



 
ENTRY TIMESTAMP   N DATE  
The date/time that the entry was entered.
UPDATE USERID   N VARCHAR2 64
The userid of the user who last updated the entry.
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 16 of 21
Application: SOSS
SIGN OUT DAILY TRACKING (cont'd) Short Name: SODT
UPDATE TIMESTAMP   N DATE  
The date/time the entry was last updated.
ACTIVE INDICATOR   N VARCHAR2 1
Determines whether the record is active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds call frequency data for one and only one CALL FREQUENCY
MAY BE shows sign-out for one and only one OFFICE EMPLOYEE
MUST BE show sign-out type codes for one and only one SIGN OUT TYPE CODE
MUST BE shows entry types for one and only one ENTRY TYPE CODE
MUST BE shows org unit for one and only one ORG UNIT
MUST BE shows signed-out entry for one and only one OFFICE EMPLOYEE
* = Relationships in primary unique identifier.
Unique Identifiers:
SODT Primary? Y
SIGN OUT DAILY TRACKING ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 17 of 21
Application: SOSS
SIGN OUT DAILY TRACKING HISTORY Short Name: SODTH
Plural: SIGN OUT DAILY TRACKING HISTORY
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
Holds information on the daily office sign outs of employees to perform MOFR activities. Tracks which employee is signing out when, how long the employee is expected to be away performing the activity, and when the employee is to check in.
Attributes:
Name Domain Opt Format Length
* SIGN OUT DAILY TRACKING HISTORY ID
   N NUMBER 10
Database generated unique identifier for records in the SIGN OUT DAILY TRACKING HISTORY table.
LAST NAME   N VARCHAR2 40
History: The last name of the employee being tracked in the Sign Out Security System.
 
FIRST NAME   N VARCHAR2 40
History: The first name of the employee being tracked in the Sign Out Security System.
MIDDLE INITIAL   Y VARCHAR2 1
History: Initial of the employees middle name.
SIGN OUT TIMESTAMP   N DATE  
History: The date/time that the employee has signed out of of the office, this begins the tracking process.
ESTIMATED SIGNIN TIMESTAMP   N DATE  
History: The date/time when the employee is estimated to sign-in, upon sign-in the employee is deemed safe.
ACTUAL SIGNIN TIMESTAMP   Y DATE  
History: The actual date/time when the employee signs-in, at this date/time the employee is deemed safe.
CURRENT CHECKIN TIMESTAMP   Y DATE  
History: The date/time when the employee will call into the office (or some other means of contacting a Safety Officer, i.e., radio) to 'check-in' and communicate that they are safe.
LOCATION DESCRIPTION   Y VARCHAR2 480
History: The location description of where the employee is.
TRANSPORTATION TYPE   Y VARCHAR2 50
History: Specifies what type of transportation will be used to reach the out-of-office location.
CHECKIN REQUIRED   N VARCHAR2 1
History: Specifies if an entry requires a check-in date/time. Entries that do not required check-ins are outings such as vacation, appointments etc.
RADIO CALL SIGN   N VARCHAR2 8
History: The radio call sign of the employee who is signed-out. MoFR from a30 to pgx025; aircraft: 6 to 8 characters; boats: usually name of boat or whatever the skipper answers too.



 
ENTRY TIMESTAMP   N DATE  
History: The date/time that the entry was entered.
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 18 of 21
Application: SOSS
SIGN OUT DAILY TRACKING HISTORY (cont'd) Short Name: SODTH
UPDATE USERID   N VARCHAR2 64
History: The userid of the user who last updated the entry.
UPDATE TIMESTAMP   N DATE  
History: The date/time the entry was last updated.
ACTIVE INDICATOR   N VARCHAR2 1
History: Determines whether the record was active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE shows call frequency data for one and only one CALL FREQUENCY
MAY BE shows sign-out for one and only one OFFICE EMPLOYEE
MUST BE show sign-out type codes for one and only one SIGN OUT TYPE CODE
MUST BE shows entry types for one and only one ENTRY TYPE CODE
MUST BE shows org unit for one and only one ORG UNIT
MUST BE shows signed-out entry for one and only one OFFICE EMPLOYEE
* = Relationships in primary unique identifier.
Unique Identifiers:
SODT Primary? Y
SIGN OUT DAILY TRACKING HISTORY ID
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 19 of 21
Application: SOSS
SIGN OUT TYPE CODE Short Name: SOTC
Plural: SIGN OUT TYPE CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
A code table representing values available for sign-out types.
Attributes:
Name Domain Opt Format Length
* SIGN OUT TYPE CODE   N VARCHAR2 10
The codes representing the different types of sign-outs.
DESCRIPTION   N VARCHAR2 120
The description of the code.
EFFECTIVE DATE   N DATE  
The effective date of the code.
EXPIRY DATE   N DATE  
The expiry date of the code.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds sign-out types for one or more SIGN OUT DAILY TRACKING
MAY BE holds sign-out types for one or more SIGN OUT DAILY TRACKING HISTORY
* = Relationships in primary unique identifier.
Unique Identifiers:
SOTC Primary? Y
SIGN OUT TYPE CODE
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 20 of 21
Application: SOSS
WORK CALL RATING XF Short Name: WCRX
Plural: WORK CALL RATING XF
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table holds the mapping between safety ratings, work description and call frequencies for each office.
Attributes:
Name Domain Opt Format Length
ACTIVE INDICATOR   N VARCHAR2 1
Determine if the record is active or not.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MUST BE shows activity safety rating codes for one and only one ACTIVITY SAFETY RATING CODE
MUST BE shows call frequency codes for one and only one CALL FREQUENCY CODE
* MUST BE shows org unit for one and only one ORG UNIT
* MUST BE shows work description codes for one and only one WORK DESCRIPTION CODE
* = Relationships in primary unique identifier.
Unique Identifiers:
WCRX Primary? Y
MUST BE shows work description codes for one and only one WORK DESCRIPTION CODE
MUST BE shows org unit for one and only one ORG UNIT
Data Administration
daqr0010
February 13, 2007 Entity Definition Report Page 21 of 21
Application: SOSS
WORK DESCRIPTION CODE Short Name: WDC
Plural: WORK DESCRIPTION CODE
Init. Volume:   Avg. Volume:   Max. Volume:   Annual Growth Rate:  
Description:
This table holds the codes and descriptions for various work activities.
Attributes:
Name Domain Opt Format Length
* WORK DESCRIPTION CODE   N VARCHAR2 10
DESCRIPTION   N VARCHAR2 120
The description of the code.
EFFECTIVE DATE   N DATE  
The effective date of the code.
EXPIRY DATE   N DATE  
The expiry date of the code.
UPDATE TIMESTAMP   N DATE  
The date/time the record was last updated.
* = Attributes in primary unique identifier.
Relationships:
Each Occurrence Of This Entity:
MAY BE holds work descriptions for one or more WORK CALL RATING XF
* = Relationships in primary unique identifier.
Unique Identifiers:
WDC Primary? Y
WORK DESCRIPTION CODE