tkMaster 
Default Table Name  tkMaster 
Definition  
Time Table - Data Entry Master
 

tkMaster Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EndDate(PK)    datetime  NO  
Timesheet period end date.
 
Employee(PK)    nvarchar(20)  NO  
Employee number.
 
EmployeeCompany(PK)    nvarchar(14)  NO  
The company to which the employee belongs.
 
Submitted    varchar(1)  NO  
Variable indicating the timesheet's submittal status. Valid options are Y-Submitted, N-Not submitted, P-Posted.
 
Selected    varchar(1)  NO  
Variable indicating whether the timesheet has been selected for posting.
 
SubmittedBy    nvarchar(20)  YES  
Employee number of the timesheet's submitter.
 
ApprovedBy    nvarchar(20)  YES  
Employee number of the timesheet's approver.
 
TKGroup    nvarchar(10)  NO  
The employee's Timekeeper group.
 
SubmittedDate    datetime  YES  
The date and time when the timesheet was submitted.
 
ApprovedDate    datetime  YES  
The date and time when the timesheet was approved.
 
CreateUser    nvarchar(20)  YES  
The username of the user logged in when the record was created.
 
CreateDate    datetime  YES  
The date and time when the record was created.
 
ModUser    nvarchar(20)  YES  
The username of the user logged in when the record was modified.
 
ModDate    datetime  YES  
The date and time when the record was modified.
 

tkMaster Primary and Unique Keys 
Key Name  Key Type  Keys 
tkMasterPK  PrimaryKey  EndDate, Employee, EmployeeCompany 

tkMaster Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication