Oracle Designer
Report : TABLE DEFINITION
Filename : C:\DOCUME~1\klmcnult\LOCALS~1\Temp\ckr1DC.tmp.html
Run by : CASEOWNER
Report Date : 13 February 2007
Total Pages : 49
Parameter Values
Workarea : GLOBAL SHARED WORKAREA
Container : SOSS
Container Version :  
Recurse Sub-Containers : N
Tab/View/Snap Name : %
Diagram :  
Includes
Tables : Yes
Views : Yes
Snapshots : Yes
Column Details : Yes
Tables Created
On/After :  
On/Before : 13 February 2007
and
Tables Changed
On/After :  
On/Before : 13 February 2007
13 February 2007 Page 2 of 49
Table Definition
Container : SOSS Version :  
Table Name : ACTIVITY_SAFETY_RATING_CODE Alias : ASRC
Display Title : Activity Safety Rating Code
   
Description : Holds activity safety rating codes.
 
User/Help Text : Holds activity safety rating codes.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 ACTIVITY_SAFETY_RATING_CODE NOT NULL VARCHAR2 (1)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
ASRC_PK ACTIVITY_SAFETY_RATING_CODE
Column Detail
1 ACTIVITY_SAFETY_RATING_CODE
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Codes for activity safety ratings.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
Description of the activity safety rating.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the activity safety rating.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date for the activity safety rating.
5 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 3 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time that the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 4 of 49
Table Definition
Container : SOSS Version :  
Table Name : CALL_FREQUENCY Alias : CF
Display Title : Call Frequency
   
Description : This table maps codes to a specific numeric value.
 
User/Help Text : This table maps codes to a specific numeric value.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 CALL_FREQUENCY_CODE NOT NULL VARCHAR2 (5)
3 CALL_FREQUENCY_VALUE NOT NULL NUMBER ()
Primary Key
Name Column
CF_PK CALL_FREQUENCY_CODE
Foreign Keys
CF_CFC_FK
CALL_FREQUENCY_CODE references CALL_FREQUENCY_CODE.CALL_FREQUENCY_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
CF_CFC_FK_I 20 CALL_FREQUENCY_CODE NOT UNIQUE
Column Detail
1 CALL_FREQUENCY_CODE
Optional ? :No ; Varchar2 (5) ;() ; ; Uppercase ? :No ;
Codes for call frequencies.
3 CALL_FREQUENCY_VALUE
Optional ? :No ; Number () ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 5 of 49
Table Definition
Container : SOSS Version :  
Column Detail
The numeric value of the code.
Oracle Designer Report : cktci
13 February 2007 Page 6 of 49
Table Definition
Container : SOSS Version :  
Table Name : CALL_FREQUENCY_CODE Alias : CFC
Display Title : Call Frequency Code
   
Description : Holds call frequency codes.
 
User/Help Text : Holds call frequency codes.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 CALL_FREQUENCY_CODE NOT NULL VARCHAR2 (5)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
CFC_PK CALL_FREQUENCY_CODE
Column Detail
1 CALL_FREQUENCY_CODE
Optional ? :No ; Varchar2 (5) ;() ; ; Uppercase ? :No ;
Codes for call frequencies.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the call frequency.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date for the call frequency code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date for the call frequency code.
5 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 7 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 8 of 49
Table Definition
Container : SOSS Version :  
Table Name : ENTRY_TYPE_CODE Alias : ETC
Display Title : Entry Type Code
   
Description : This code table represents the values available for sign-out entry types.
 
User/Help Text : This code table represents the values available for sign-out entry types.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 ENTRY_TYPE_CODE NOT NULL VARCHAR2 (10)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
ETC_PK ENTRY_TYPE_CODE
Column Detail
1 ENTRY_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
Codes representing the available values for sign-out entry types.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the code.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date of the code.
Oracle Designer Report : cktci
13 February 2007 Page 9 of 49
Table Definition
Container : SOSS Version :  
Column Detail
5 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 10 of 49
Table Definition
Container : SOSS Version :  
Table Name : OFFICE_EMPLOYEE Alias : EMP
Display Title : Office Employee
   
Description : This table determines which employees belong to which office and any preferences for that employee.
 
User/Help Text : This table determines which employees belong to which office and any preferences for that employee.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 EMPLOYEE_USERID NOT NULL VARCHAR2 (64)
2 ORG_UNIT_NO NOT NULL NUMBER (10)
3 RADIO_CALL_SIGN NOT NULL VARCHAR2 (8)
4 PROGRAM_DESCRIPTION NOT NULL VARCHAR2 (250)
5 FIRST_NAME NOT NULL VARCHAR2 (40)
6 LAST_NAME NOT NULL VARCHAR2 (40)
7 MIDDLE_INITIAL NULL VARCHAR2 (1)
8 TELEPHONE_NUMBER NULL VARCHAR2 (10)
9 ACTIVE_IND NOT NULL VARCHAR2 (1)
10 ENTRY_USERID NOT NULL VARCHAR2 (64)
11 ENTRY_TIMESTAMP NOT NULL DATE
12 UPDATE_USERID NOT NULL VARCHAR2 (64)
14 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
EMP_PK EMPLOYEE_USERID
ORG_UNIT_NO
Foreign Keys
EMP_OP_FK
ORG_UNIT_NO references OFFICE_PREFERENCE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Oracle Designer Report : cktci
13 February 2007 Page 11 of 49
Table Definition
Container : SOSS Version :  
Index Summary
Name Seq. Column Index Type
EMP_OP_FK_I 20 ORG_UNIT_NO NOT UNIQUE
Column Detail
1 EMPLOYEE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
2 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
3 RADIO_CALL_SIGN
Optional ? :No ; Varchar2 (8) ;() ; ; Uppercase ? :No ;
The radio call sign for the employee.
4 PROGRAM_DESCRIPTION
Optional ? :No ; Varchar2 (250) ;() ; ; Uppercase ? :No ;
The program the employee belongs to.
5 FIRST_NAME
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
6 LAST_NAME
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
7 MIDDLE_INITIAL
Optional ? :Yes ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
8 TELEPHONE_NUMBER
Optional ? :Yes ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
9 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Determines whether the record is active or not.
10 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who created the record.
11 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was created.
12 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who last updated the record.
14 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 12 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 13 of 49
Table Definition
Container : SOSS Version :  
Table Name : OFFICE_PREFERENCE Alias : OP
Display Title : Office Preference
   
Description : The table holds the offices and their preferences that are available to the application.
 
User/Help Text : The table holds the offices and their preferences that are available to the application.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 ORG_UNIT_NO NOT NULL NUMBER (10)
2 OFFICE_DESCRIPTION NOT NULL VARCHAR2 (100)
3 CHECKIN_REQUIRED_INDICATOR NOT NULL VARCHAR2 (1)
4 ENTRY_USERID NOT NULL VARCHAR2 (64)
5 ENTRY_TIMESTAMP NOT NULL DATE
6 UPDATE_USERID NOT NULL VARCHAR2 (64)
8 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
OP_PK ORG_UNIT_NO
Foreign Keys
OP_OU_FK
ORG_UNIT_NO references ORG_UNIT.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
OP_OU_FK_I 20 ORG_UNIT_NO NOT UNIQUE
Column Detail
Oracle Designer Report : cktci
13 February 2007 Page 14 of 49
Table Definition
Container : SOSS Version :  
Column Detail
1 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
2 OFFICE_DESCRIPTION
Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ;
The description of the office, i.e., South Island Forest District.
3 CHECKIN_REQUIRED_INDICATOR
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
An Y/N indicator which identifies if the office default for check-in required is Yes or No.
4 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who created the record.
5 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The time the record was created.
6 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who last updated the record.
8 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 15 of 49
Table Definition
Container : SOSS Version :  
Table Name : OFFICE_RESOURCE Alias : RES
Display Title : Office Resource
   
Description : This table holds the resources and their associated information available for sign-out.
 
User/Help Text : This table holds the resources and their associated information available for sign-out.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 RESOURCE_ID NOT NULL NUMBER (10)
2 IDENTIFIER NOT NULL VARCHAR2 (100)
3 DESCRIPTION NOT NULL VARCHAR2 (400)
4 CONTACT_NAME NOT NULL VARCHAR2 (100)
5 CATEGORY_ID NOT NULL NUMBER ()
6 RESOURCE_STATUS_CODE NOT NULL VARCHAR2 (10)
7 RESOURCE_PRIORITY_CODE NOT NULL VARCHAR2 (10)
8 ORG_UNIT_NO NOT NULL NUMBER (10)
10 ENTRY_USERID NOT NULL VARCHAR2 (64)
12 ENTRY_TIMESTAMP NOT NULL DATE
14 UPDATE_USERID NOT NULL VARCHAR2 (64)
16 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
RES_PK RESOURCE_ID
Column Detail
1 RESOURCE_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
A unique identifier for the resource record.
2 IDENTIFIER
Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 16 of 49
Table Definition
Container : SOSS Version :  
Foreign Keys
RES_CAT_FK
CATEGORY_ID references OFFICE_RESOURCE_CATEGORY.CATEGORY_ID
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
RES_OP_FK
ORG_UNIT_NO references OFFICE_PREFERENCE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
RES_RPC_FK
RESOURCE_PRIORITY_CODE references RESOURCE_PRIORITY_CODE.RESOURCE_PRIORITY_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
RES_RSC_FK
RESOURCE_STATUS_CODE references RESOURCE_STATUS_CODE.RESOURCE_STATUS_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
RES_CAT_FK_I 20 CATEGORY_ID NOT UNIQUE
RES_OP_FK_I 20 ORG_UNIT_NO NOT UNIQUE
RES_RPC_FK_I 20 RESOURCE_PRIORITY_CODE NOT UNIQUE
RES_RSC_FK_I 20 RESOURCE_STATUS_CODE NOT UNIQUE
Column Detail
Holds a value which identifies the resource. i.e. VE65421-2000.
3 DESCRIPTION
Optional ? :No ; Varchar2 (400) ;() ; ; Uppercase ? :No ;
Holds a description of the resource.
4 CONTACT_NAME
Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ;
Holds the contact name for the resource.
5 CATEGORY_ID
Optional ? :No ; Number () ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 17 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Unique identifier for the category.
6 RESOURCE_STATUS_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
Unique code for a resource status.
7 RESOURCE_PRIORITY_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
The code representing a resource priority.
8 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
10 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who intially created the resource record.
12 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the resource entry was created.
14 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who last updated the record.
16 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 18 of 49
Table Definition
Container : SOSS Version :  
Table Name : OFFICE_RESOURCE_CATEGORY Alias : CAT
Display Title : Office Resource Category
   
Description : This table identifies ten categories for each office that they can place resources into.
 
User/Help Text : This table identifies ten categories for each office that they can place resources into.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 CATEGORY_ID NOT NULL NUMBER ()
2 ORG_UNIT_NO NOT NULL NUMBER (10)
4 NAME NOT NULL VARCHAR2 (500)
Primary Key
Name Column
CAT_PK CATEGORY_ID
Foreign Keys
CAT_OP_FK
ORG_UNIT_NO references OFFICE_PREFERENCE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
CAT_OP_FK_I 20 ORG_UNIT_NO NOT UNIQUE
Column Detail
1 CATEGORY_ID
Optional ? :No ; Number () ;() ; ; Uppercase ? :No ;
Unique identifier for the category.
2 ORG_UNIT_NO
Oracle Designer Report : cktci
13 February 2007 Page 19 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
4 NAME
Optional ? :No ; Varchar2 (500) ;() ; ; Uppercase ? :No ;
Name of the category.
Oracle Designer Report : cktci
13 February 2007 Page 20 of 49
Table Definition
Container : SOSS Version :  
Table Name : ORG_UNIT Alias : OU
Display Title : Org Unit
   
Description : Ministry maintained table that contains all org units.
 
User/Help Text : Ministry maintained table that contains all org units.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 ORG_UNIT_NO NOT NULL NUMBER (10)
2 ORG_UNIT_NAME NOT NULL VARCHAR2 (100)
Primary Key
Name Column
OU_PK ORG_UNIT_NO
Column Detail
1 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
2 ORG_UNIT_NAME
Optional ? :No ; Varchar2 (100) ;() ; ; Uppercase ? :No ;
The name of the org unit.
Oracle Designer Report : cktci
13 February 2007 Page 21 of 49
Table Definition
Container : SOSS Version :  
Table Name : RESOURCE_DAILY_TRACKING Alias : RDT
Display Title : Resource Daily Tracking
   
Description : This table holds data the identifies which resources are signed-out and when.
 
User/Help Text : This table holds data the identifies which resources are signed-out and when.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 RESOURCE_DAILY_TRACKING_ID NOT NULL NUMBER (10)
2 SIGN_OUT_TIMESTAMP NOT NULL DATE
3 ESTIMATED_SIGNIN_TIMESTAMP NOT NULL DATE
4 ACTUAL_SIGNIN_TIMESTAMP NULL DATE
5 LOCATION_DESCRIPTION NULL VARCHAR2 (480)
7 RESOURCE_ID NOT NULL NUMBER (10)
8 ORG_UNIT_NO NOT NULL NUMBER (10)
9 ACTIVE_IND NOT NULL VARCHAR2 (1)
10 ENTRY_USERID NOT NULL VARCHAR2 (64)
12 ENTRY_TIMESTAMP NOT NULL DATE
14 UPDATE_USERID NOT NULL VARCHAR2 (64)
15 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
RDT_PK RESOURCE_DAILY_TRACKING_ID
Column Detail
1 RESOURCE_DAILY_TRACKING_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
A unique id for the resource sign-out.
2 SIGN_OUT_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 22 of 49
Table Definition
Container : SOSS Version :  
Foreign Keys
RDT_EMP_FK
ENTRY_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
RDT_RES_FK
RESOURCE_ID references OFFICE_RESOURCE.RESOURCE_ID
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
RDT_EMP_FK_I 20 ENTRY_USERID NOT UNIQUE
RDT_EMP_FK_I 40 ORG_UNIT_NO NOT UNIQUE
RDT_RES_FK_I 20 RESOURCE_ID NOT UNIQUE
Column Detail
The date/time the resource was signed out.
3 ESTIMATED_SIGNIN_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The data/time the resource is expected to be returned.
4 ACTUAL_SIGNIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
The date/time the resource was actually returned.
5 LOCATION_DESCRIPTION
Optional ? :Yes ; Varchar2 (480) ;() ; ; Uppercase ? :No ;
A freeform description identifying where the resource is and the purpose of the sign-out.
7 RESOURCE_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
A unique identifier for the resource record.
8 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
9 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
A indicator determing whether the record is active or not.
Oracle Designer Report : cktci
13 February 2007 Page 23 of 49
Table Definition
Container : SOSS Version :  
Column Detail
10 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
12 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the entry was entered.
14 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The user who last updated the sign-out.
15 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The last date/time the resource entry was updated.
Oracle Designer Report : cktci
13 February 2007 Page 24 of 49
Table Definition
Container : SOSS Version :  
Table Name : RESOURCE_DAILY_TRACKING_HSTRY
 Alias : RDTH
Display Title : Resource Daily Tracking Histor
   
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.
 
User/Help Text : 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.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 RESOURCE_DAILY_TRACKING_ID NOT NULL NUMBER (10)
2 SIGN_OUT_TIMESTAMP NOT NULL DATE
3 ESTIMATED_SIGNIN_TIMESTAMP NOT NULL DATE
4 ACTUAL_SIGNIN_TIMESTAMP NULL DATE
5 LOCATION_DESCRIPTION NOT NULL VARCHAR2 (480)
7 RESOURCE_ID NOT NULL NUMBER (10)
8 ORG_UNIT_NO NOT NULL NUMBER (10)
9 ACTIVE_IND NOT NULL VARCHAR2 (1)
10 ENTRY_USERID NOT NULL VARCHAR2 (64)
12 ENTRY_TIMESTAMP NOT NULL DATE
14 UPDATE_USERID NOT NULL VARCHAR2 (64)
15 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
RDTH_PK RESOURCE_DAILY_TRACKING_ID
Column Detail
1 RESOURCE_DAILY_TRACKING_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
2 SIGN_OUT_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 25 of 49
Table Definition
Container : SOSS Version :  
Foreign Keys
RDTH_EMP_FK
ENTRY_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
RDTH_RES_FK
RESOURCE_ID references OFFICE_RESOURCE.RESOURCE_ID
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
RDTH_EMP_FK_I 20 ENTRY_USERID NOT UNIQUE
RDTH_EMP_FK_I 40 ORG_UNIT_NO NOT UNIQUE
RDTH_RES_FK_I 20 RESOURCE_ID NOT UNIQUE
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time the resource was signed-out.
3 ESTIMATED_SIGNIN_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The estimated date/time the resource was expected to be returned.
4 ACTUAL_SIGNIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
History: The actual date/time the resource was returned.
5 LOCATION_DESCRIPTION
Optional ? :No ; Varchar2 (480) ;() ; ; Uppercase ? :No ;
History: The location/purpose of the resources sign-out.
7 RESOURCE_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
A unique identifier for the resource record.
8 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
9 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 26 of 49
Table Definition
Container : SOSS Version :  
Column Detail
History: Determines whether the record was active or not.
10 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
12 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time the entry was created.
14 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
History: The user who last updated the record.
15 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 27 of 49
Table Definition
Container : SOSS Version :  
Table Name : RESOURCE_PRIORITY_CODE Alias : RPC
Display Title : Resource Priority Code
   
Description : This code table represents the codes available for resource priorities.
 
User/Help Text : This code table represents the codes available for resource priorities.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 RESOURCE_PRIORITY_CODE NOT NULL VARCHAR2 (10)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
RPC_PK RESOURCE_PRIORITY_CODE
Column Detail
1 RESOURCE_PRIORITY_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
The code representing a resource priority.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the resource priority.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date of the code.
Oracle Designer Report : cktci
13 February 2007 Page 28 of 49
Table Definition
Container : SOSS Version :  
Column Detail
5 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 29 of 49
Table Definition
Container : SOSS Version :  
Table Name : RESOURCE_STATUS_CODE Alias : RSC
Display Title : Resource Status Code
   
Description : Identifies code values for resource statuses.
 
User/Help Text : Identifies code values for resource statuses.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 RESOURCE_STATUS_CODE NOT NULL VARCHAR2 (10)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
RSC_PK RESOURCE_STATUS_CODE
Column Detail
1 RESOURCE_STATUS_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
Unique code for a resource status.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the code.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date of the code.
5 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 30 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the code was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 31 of 49
Table Definition
Container : SOSS Version :  
Table Name : SAFETY_JURISDICTION Alias : SJ
Display Title : Safety Jurisdiction
   
Description : The table relates org units to a city and a specific timezone.
 
User/Help Text : The table relates org units to a city and a specific timezone.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 CITY NOT NULL VARCHAR2 (50)
2 ORG_UNIT_NO NOT NULL NUMBER (10)
4 TIMEZONE NOT NULL VARCHAR2 (40)
Primary Key
Name Column
SJ_PK CITY
ORG_UNIT_NO
Foreign Keys
SJ_OU_FK
ORG_UNIT_NO references ORG_UNIT.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
SJ_OU_FK_I 20 ORG_UNIT_NO NOT UNIQUE
Column Detail
1 CITY
Optional ? :No ; Varchar2 (50) ;() ; ; Uppercase ? :No ;
The city relating to the org unit and time zone.
2 ORG_UNIT_NO
Oracle Designer Report : cktci
13 February 2007 Page 32 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
4 TIMEZONE
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
The timezone for the specific city.
Oracle Designer Report : cktci
13 February 2007 Page 33 of 49
Table Definition
Container : SOSS Version :  
Table Name : SIGN_OUT_DAILY_TRACKING Alias : SODT
Display Title : Sign Out Daily Tracking
   
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.
 
User/Help Text : 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.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 SIGN_OUT_DAILY_TRACKING_ID NOT NULL NUMBER (10)
2 LAST_NAME NOT NULL VARCHAR2 (40)
3 FIRST_NAME NOT NULL VARCHAR2 (40)
4 MIDDLE_INITIAL NULL VARCHAR2 (1)
5 SIGN_OUT_TIMESTAMP NOT NULL DATE
6 ESTIMATED_SIGNIN_TIMESTAMP NOT NULL DATE
7 ACTUAL_SIGNIN_TIMESTAMP NULL DATE
8 CURRENT_CHECKIN_TIMESTAMP NULL DATE
9 LOCATION_DESCRIPTION NULL VARCHAR2 (480)
10 TRANSPORTATION_TYPE NULL VARCHAR2 (50)
11 CHECKIN_REQUIRED NOT NULL VARCHAR2 (1)
12 RADIO_CALL_SIGN NOT NULL VARCHAR2 (8)
13 ENTRY_TYPE_CODE NOT NULL VARCHAR2 (10)
14 SIGN_OUT_TYPE_CODE NOT NULL VARCHAR2 (10)
15 CALL_FREQUENCY_CODE NULL VARCHAR2 (5)
16 EMPLOYEE_USERID NULL VARCHAR2 (64)
18 EMPLOYEE_ORG_UNIT_NO NULL NUMBER (10)
20 ORG_UNIT_NO NOT NULL NUMBER (10)
22 ACTIVE_IND NOT NULL VARCHAR2 (1)
24 ENTRY_USERID NOT NULL VARCHAR2 (64)
26 ENTRY_TIMESTAMP NOT NULL DATE
28 UPDATE_USERID NOT NULL VARCHAR2 (64)
Oracle Designer Report : cktci
13 February 2007 Page 34 of 49
Table Definition
Container : SOSS Version :  
Col.Seq. Column Nulls ? Type
30 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
SODT_PK SIGN_OUT_DAILY_TRACKING_ID
Foreign Keys
SODT2_EMP_FK
EMPLOYEE_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
EMPLOYEE_ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? No Delete Rule : Restricted
SODT_CF_FK
CALL_FREQUENCY_CODE references CALL_FREQUENCY.CALL_FREQUENCY_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODT_EMP_FK
ENTRY_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODT_ETC_FK
ENTRY_TYPE_CODE references ENTRY_TYPE_CODE.ENTRY_TYPE_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODT_SOTC_FK
SIGN_OUT_TYPE_CODE references SIGN_OUT_TYPE_CODE.SIGN_OUT_TYPE_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Column Detail
1 SIGN_OUT_DAILY_TRACKING_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
Database generated unique identifier for records in the SIGN OUT DAILY TRACKING table.
2 LAST_NAME
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
Oracle Designer Report : cktci
13 February 2007 Page 35 of 49
Table Definition
Container : SOSS Version :  
Index Summary
Name Seq. Column Index Type
SODTSHOWS_SIGNED_OUT_ENTRY___I 20 ENTRY_USERID NOT UNIQUE
SODTSHOWS_SIGNED_OUT_ENTRY___I 40 ORG_UNIT_NO NOT UNIQUE
SODT_CF_FK_I 20 CALL_FREQUENCY_CODE NOT UNIQUE
SODT_EMP_FK_I 20 EMPLOYEE_USERID NOT UNIQUE
SODT_EMP_FK_I 40 EMPLOYEE_ORG_UNIT_NO NOT UNIQUE
SODT_ETC_FK_I 20 ENTRY_TYPE_CODE NOT UNIQUE
SODT_SOTC_FK_I 20 SIGN_OUT_TYPE_CODE NOT UNIQUE
Column Detail
The last name of the employee being tracked in the Sign Out Security System.
 
3 FIRST_NAME
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
The first name of the employee being tracked in the Sign Out Security System.
4 MIDDLE_INITIAL
Optional ? :Yes ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Initial of the employees middle name.
5 SIGN_OUT_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time that the employee has signed out of of the office, this begins the tracking process.
6 ESTIMATED_SIGNIN_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time when the employee is estimated to sign-in, upon sign-in the employee is deemed safe.
7 ACTUAL_SIGNIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
The actual date/time when the employee signs-in, at this date/time the employee is deemed safe.
8 CURRENT_CHECKIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
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.
9 LOCATION_DESCRIPTION
Optional ? :Yes ; Varchar2 (480) ;() ; ; Uppercase ? :No ;
The location description of where the employee is.
Oracle Designer Report : cktci
13 February 2007 Page 36 of 49
Table Definition
Container : SOSS Version :  
Column Detail
10 TRANSPORTATION_TYPE
Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;
Specifies what type of transportation will be used to reach the out-of-office location.
11 CHECKIN_REQUIRED
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Specifies if an entry requires a check-in date/time. Entries that do not required check-ins are outings such as vacation, appointments etc.
12 RADIO_CALL_SIGN
Optional ? :No ; Varchar2 (8) ;() ; ; Uppercase ? :No ;
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.



 
13 ENTRY_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
Codes representing the available values for sign-out entry types.
14 SIGN_OUT_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
The codes representing the different types of sign-outs.
15 CALL_FREQUENCY_CODE
Optional ? :Yes ; Varchar2 (5) ;() ; ; Uppercase ? :No ;
Codes for call frequencies.
16 EMPLOYEE_USERID
Optional ? :Yes ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
18 EMPLOYEE_ORG_UNIT_NO
Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
20 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
22 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Determines whether the record is active or not.
24 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
Oracle Designer Report : cktci
13 February 2007 Page 37 of 49
Table Definition
Container : SOSS Version :  
Column Detail
26 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time that the entry was entered.
28 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The userid of the user who last updated the entry.
30 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the entry was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 38 of 49
Table Definition
Container : SOSS Version :  
Table Name : SIGN_OUT_DAILY_TRACKING_HSTRY
 Alias : SODTH
Display Title : Sign Out Daily Tracking Histor
   
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.
 
User/Help Text : 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.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 SIGN_OUT_DAILY_TRACKING_ID NOT NULL NUMBER (10)
2 LAST_NAME NOT NULL VARCHAR2 (40)
3 FIRST_NAME NOT NULL VARCHAR2 (40)
4 MIDDLE_INITIAL NULL VARCHAR2 (1)
5 SIGN_OUT_TIMESTAMP NOT NULL DATE
6 ESTIMATED_SIGNIN_TIMESTAMP NOT NULL DATE
7 ACTUAL_SIGNIN_TIMESTAMP NULL DATE
8 CURRENT_CHECKIN_TIMESTAMP NULL DATE
9 LOCATION_DESCRIPTION NULL VARCHAR2 (480)
10 TRANSPORTATION_TYPE NULL VARCHAR2 (50)
11 CHECKIN_REQUIRED NOT NULL VARCHAR2 (1)
12 RADIO_CALL_SIGN NOT NULL VARCHAR2 (8)
13 ENTRY_TYPE_CODE NOT NULL VARCHAR2 (10)
14 SIGN_OUT_TYPE_CODE NOT NULL VARCHAR2 (10)
15 CALL_FREQUENCY_CODE NULL VARCHAR2 (5)
16 EMPLOYEE_USERID NULL VARCHAR2 (64)
18 EMPLOYEE_ORG_UNIT_NO NULL NUMBER (10)
20 ORG_UNIT_NO NOT NULL NUMBER (10)
22 ACTIVE_IND NOT NULL VARCHAR2 (1)
24 ENTRY_USERID NOT NULL VARCHAR2 (64)
26 ENTRY_TIMESTAMP NOT NULL DATE
Oracle Designer Report : cktci
13 February 2007 Page 39 of 49
Table Definition
Container : SOSS Version :  
Col.Seq. Column Nulls ? Type
28 UPDATE_USERID NOT NULL VARCHAR2 (64)
30 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
SODTH_PK SIGN_OUT_DAILY_TRACKING_ID
Foreign Keys
SODTH2_EMP__FK
ENTRY_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODTH_CF_FK
CALL_FREQUENCY_CODE references CALL_FREQUENCY.CALL_FREQUENCY_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODTH_EMP_FK
EMPLOYEE_USERID references OFFICE_EMPLOYEE.EMPLOYEE_USERID
EMPLOYEE_ORG_UNIT_NO references OFFICE_EMPLOYEE.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? No Delete Rule : Restricted
SODTH_ETC_FK
ENTRY_TYPE_CODE references ENTRY_TYPE_CODE.ENTRY_TYPE_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
SODTH_SOTC_FK
SIGN_OUT_TYPE_CODE references SIGN_OUT_TYPE_CODE.SIGN_OUT_TYPE_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Column Detail
1 SIGN_OUT_DAILY_TRACKING_ID
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
Database generated unique identifier for records in the SIGN OUT DAILY TRACKING HISTORY table.
2 LAST_NAME
Oracle Designer Report : cktci
13 February 2007 Page 40 of 49
Table Definition
Container : SOSS Version :  
Index Summary
Name Seq. Column Index Type
SODTH_CF_FK_I 20 CALL_FREQUENCY_CODE NOT UNIQUE
SODTH_EMP_FK_I 20 EMPLOYEE_USERID NOT UNIQUE
SODTH_EMP_FK_I 40 EMPLOYEE_ORG_UNIT_NO NOT UNIQUE
SODTH_ETC_FK_I 20 ENTRY_TYPE_CODE NOT UNIQUE
SODTH_SOTC_FK_I 20 SIGN_OUT_TYPE_CODE NOT UNIQUE
SODTSHOWS_SIGNED_OUT_ENTRY___1 20 ENTRY_USERID NOT UNIQUE
SODTSHOWS_SIGNED_OUT_ENTRY___1 40 ORG_UNIT_NO NOT UNIQUE
Column Detail
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
History: The last name of the employee being tracked in the Sign Out Security System.
 
3 FIRST_NAME
Optional ? :No ; Varchar2 (40) ;() ; ; Uppercase ? :No ;
History: The first name of the employee being tracked in the Sign Out Security System.
4 MIDDLE_INITIAL
Optional ? :Yes ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
History: Initial of the employees middle name.
5 SIGN_OUT_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time that the employee has signed out of of the office, this begins the tracking process.
6 ESTIMATED_SIGNIN_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time when the employee is estimated to sign-in, upon sign-in the employee is deemed safe.
7 ACTUAL_SIGNIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
History: The actual date/time when the employee signs-in, at this date/time the employee is deemed safe.
8 CURRENT_CHECKIN_TIMESTAMP
Optional ? :Yes ; Date ;() ; ; Uppercase ? :No ;
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.
Oracle Designer Report : cktci
13 February 2007 Page 41 of 49
Table Definition
Container : SOSS Version :  
Column Detail
9 LOCATION_DESCRIPTION
Optional ? :Yes ; Varchar2 (480) ;() ; ; Uppercase ? :No ;
History: The location description of where the employee is.
10 TRANSPORTATION_TYPE
Optional ? :Yes ; Varchar2 (50) ;() ; ; Uppercase ? :No ;
History: Specifies what type of transportation will be used to reach the out- of-office location.
11 CHECKIN_REQUIRED
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
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.
12 RADIO_CALL_SIGN
Optional ? :No ; Varchar2 (8) ;() ; ; Uppercase ? :No ;
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.



 
13 ENTRY_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
Codes representing the available values for sign-out entry types.
14 SIGN_OUT_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
The codes representing the different types of sign-outs.
15 CALL_FREQUENCY_CODE
Optional ? :Yes ; Varchar2 (5) ;() ; ; Uppercase ? :No ;
Codes for call frequencies.
16 EMPLOYEE_USERID
Optional ? :Yes ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
18 EMPLOYEE_ORG_UNIT_NO
Optional ? :Yes ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
20 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
22 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
History: Determines whether the record was active or not.
Oracle Designer Report : cktci
13 February 2007 Page 42 of 49
Table Definition
Container : SOSS Version :  
Column Detail
24 ENTRY_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
The unique userid for the employee.
26 ENTRY_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time that the entry was entered.
28 UPDATE_USERID
Optional ? :No ; Varchar2 (64) ;() ; ; Uppercase ? :No ;
History: The userid of the user who last updated the entry.
30 UPDATE_TIMESTAMP
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
History: The date/time the entry was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 43 of 49
Table Definition
Container : SOSS Version :  
Table Name : SIGN_OUT_TYPE_CODE Alias : SOTC
Display Title : Sign Out Type Code
   
Description : A code table representing values available for sign-out types.
 
User/Help Text : A code table representing values available for sign-out types.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 SIGN_OUT_TYPE_CODE NOT NULL VARCHAR2 (10)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
SOTC_PK SIGN_OUT_TYPE_CODE
Column Detail
1 SIGN_OUT_TYPE_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
The codes representing the different types of sign-outs.
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the code.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date of the code.
5 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 44 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
13 February 2007 Page 45 of 49
Table Definition
Container : SOSS Version :  
Table Name : WORK_CALL_RATING_XF Alias : WCRX
Display Title : Work Call Rating Xf
   
Description : This table holds the mapping between safety ratings, work description and call frequencies for each office.
 
User/Help Text : This table holds the mapping between safety ratings, work description and call frequencies for each office.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 ORG_UNIT_NO NOT NULL NUMBER (10)
3 WORK_DESCRIPTION_CODE NOT NULL VARCHAR2 (10)
5 CALL_FREQUENCY_CODE NOT NULL VARCHAR2 (5)
7 ACTIVITY_SAFETY_RATING_CODE NOT NULL VARCHAR2 (1)
9 ACTIVE_IND NOT NULL VARCHAR2 (1)
Primary Key
Name Column
WCRX_PK WORK_DESCRIPTION_CODE
ORG_UNIT_NO
Column Detail
1 ORG_UNIT_NO
Optional ? :No ; Number (10) ;() ; ; Uppercase ? :No ;
The number of the org unit.
3 WORK_DESCRIPTION_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
5 CALL_FREQUENCY_CODE
Optional ? :No ; Varchar2 (5) ;() ; ; Uppercase ? :No ;
Codes for call frequencies.
7 ACTIVITY_SAFETY_RATING_CODE
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Codes for activity safety ratings.
Oracle Designer Report : cktci
13 February 2007 Page 46 of 49
Table Definition
Container : SOSS Version :  
Foreign Keys
WCRX_ASRC_FK
ACTIVITY_SAFETY_RATING_CODE references ACTIVITY_SAFETY_RATING_CODE.ACTIVITY_SAFETY_RATING_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
WCRX_CFC_FK
CALL_FREQUENCY_CODE references CALL_FREQUENCY_CODE.CALL_FREQUENCY_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
WCRX_OU_FK
ORG_UNIT_NO references ORG_UNIT.ORG_UNIT_NO
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
WCRX_WDC_FK
WORK_DESCRIPTION_CODE references WORK_DESCRIPTION_CODE.WORK_DESCRIPTION_CODE
Transferable ? Yes Update Rule : Restricted
Mandatory ? Yes Delete Rule : Restricted
Index Summary
Name Seq. Column Index Type
WCRX_ASRC_FK_I 60 ACTIVITY_SAFETY_RATING_COD E
 NOT UNIQUE
WCRX_CFC_FK_I 20 CALL_FREQUENCY_CODE NOT UNIQUE
WCRX_OU_FK_I 20 ORG_UNIT_NO NOT UNIQUE
WCRX_WDC_FK_I 20 WORK_DESCRIPTION_CODE NOT UNIQUE
Column Detail
9 ACTIVE_IND
Optional ? :No ; Varchar2 (1) ;() ; ; Uppercase ? :No ;
Determine if the record is active or not.
Oracle Designer Report : cktci
13 February 2007 Page 47 of 49
Table Definition
Container : SOSS Version :  
Table Name : WORK_DESCRIPTION_CODE Alias : WDC
Display Title : Work Description Code
   
Description : This table holds the codes and descriptions for various work activities.
 
User/Help Text : This table holds the codes and descriptions for various work activities.
 
Volumes
Start Rows :   End Rows :  
Storage
Index-organized ? No
 
Column Summary
Col.Seq. Column Nulls ? Type
1 WORK_DESCRIPTION_CODE NOT NULL VARCHAR2 (10)
2 DESCRIPTION NOT NULL VARCHAR2 (120)
3 EFFECTIVE_DATE NOT NULL DATE
4 EXPIRY_DATE NOT NULL DATE
5 UPDATE_TIMESTAMP NOT NULL DATE
Primary Key
Name Column
WDC_PK WORK_DESCRIPTION_CODE
Column Detail
1 WORK_DESCRIPTION_CODE
Optional ? :No ; Varchar2 (10) ;() ; ; Uppercase ? :No ;
2 DESCRIPTION
Optional ? :No ; Varchar2 (120) ;() ; ; Uppercase ? :No ;
The description of the code.
3 EFFECTIVE_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The effective date of the code.
4 EXPIRY_DATE
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The expiry date of the code.
5 UPDATE_TIMESTAMP
Oracle Designer Report : cktci
13 February 2007 Page 48 of 49
Table Definition
Container : SOSS Version :  
Column Detail
Optional ? :No ; Date ;() ; ; Uppercase ? :No ;
The date/time the record was last updated.
Oracle Designer Report : cktci
Oracle Designer
TABLE DEFINITION
End of Report