SuperHRDatabaseDesign.xml100666 0 0 3122332 10473202516 11031 Companies 0 The Company database includes tables that manage your company and its organization and facilities. Department PT A department is an organizational subdivision of your company. N Y DepartmentID SurrogateKey Department Surrogate key for this table This value is the system-generated SurrogateKey for this table. Its value is 1 for the first row, increasing by 1 for each new row. This assures that each row's value is unique and therefore suitable for a primary key value. SurrogateKey Number 22 0 N Y Y N 10 #,##0 #,##0 Department |Department Y 10 #,##0 Y DB2 DEPARTMENT_ID EnterpriseDB department_id MSSQL DEPARTMENT_ID MySQL DEPARTMENT_ID Oracle DEPARTMENT_ID Sybase DEPARTMENT_ID SQ Department SEQUENCE Name HRName Name Enter the unique name This is the full name of this person or company. Department Character 50 INSENSITIVE Y Y Y Y 25 @ @ 1 Name |Name Y 20 @ N DB2 NAME EnterpriseDB name MSSQL NAME MySQL NAME Oracle NAME Sybase NAME ParentDepartmentID DepartmentID Parent department Pick the department in your company Pick the department in your company. Department Number 22 0 N Y N Y 10 #,##0 #,##0 Parent department |Parent department Y 30 #,##0 N DB2 PRNT_DPRTMNT_ID EnterpriseDB parent_department_id MSSQL PARENT_DEPARTMENT_ID MySQL PARENT_DEPARTMENT_ID Oracle PARENT_DEPARTMENT_ID Sybase PARENT_DEPARTMENT_ID OfficeLocationID OfficeLocationID Office location Pick a location at which your company does business Pick a location at which your company does business. Department Number 22 0 N Y N Y 10 #,##0 #,##0 Office location |Office location Y 40 #,##0 N DB2 OFFICE_LOCATION_ID EnterpriseDB office_location_id MSSQL OFFICE_LOCATION_ID MySQL OFFICE_LOCATION_ID Oracle OFFICE_LOCATION_ID Sybase OFFICE_LOCATION_ID ManagerID StaffMemberID Manager Pick an employee or other staff member Pick an employee or other staff member. Department Number 22 0 N Y N Y 10 #,##0 #,##0 Manager |Manager Y 50 #,##0 N DB2 MANAGER_ID EnterpriseDB manager_id MSSQL MANAGER_ID MySQL MANAGER_ID Oracle MANAGER_ID Sybase MANAGER_ID Description HRDescription Description Enter a brief description of this department Enter a brief description of this department. Department Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 60 @ N DB2 DESCRIPTION EnterpriseDB description MSSQL DESCRIPTION MySQL DESCRIPTION Oracle DESCRIPTION Sybase DESCRIPTION CreationDateTime CreationDateTime Creation date and time The date and time that this instance was created This value represent the full date and time that this table row was created. WhoColumns DateTime 19 N Y Y N 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Creation date time |Creation date time N 200020 MM/DD/YYYY HH24:MI:SS Y DB2 CREATION_DATE_TIME EnterpriseDB creation_date_time MSSQL CREATION_DATE_TIME MySQL CREATION_DATE_TIME Oracle CREATION_DATE_TIME Sybase CREATION_DATE_TIME SV DBToday SYSTEMVARIABLE CreatedBy CreatedBy Created by The person who created this instance This value represent the end-user who created this table row. WhoColumns Number 22 0 N Y Y N 10 #,##0 #,##0 Created by |Created by N 200030 #,##0 Y DB2 CREATED_BY EnterpriseDB created_by MSSQL CREATED_BY MySQL CREATED_BY Oracle CREATED_BY Sybase CREATED_BY SV EndUserID SYSTEMVARIABLE LastUpdateDateTime LastUpdateDateTime Last update date and time The date and time that this instance was last updated This value represents the date and time when this table row was most recently updated. WhoColumns DateTime 19 N Y Y Y 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Last update date time |Last update date time N 200040 MM/DD/YYYY HH24:MI:SS Y DB2 LST_UPDT_DT_TM EnterpriseDB last_update_date_time MSSQL LAST_UPDATE_DATE_TIME MySQL LAST_UPDATE_DATE_TIME Oracle LAST_UPDATE_DATE_TIME Sybase LAST_UPDATE_DATE_TIME SV DBToday SYSTEMVARIABLE LastUpdatedBy LastUpdatedBy Last updated by The person who last updated this instance This value represent the end-user who most recently updated this table row. WhoColumns Number 22 0 N Y Y Y 10 #,##0 #,##0 Last updated by |Last updated by N 200050 #,##0 Y DB2 LAST_UPDATED_BY EnterpriseDB last_updated_by MSSQL LAST_UPDATED_BY MySQL LAST_UPDATED_BY Oracle LAST_UPDATED_BY Sybase LAST_UPDATED_BY SV EndUserID SYSTEMVARIABLE LastUpdatingProcess LastUpdatingProcess Last updating process The name of the transaction, TaskEngine, et cetera that last updated this instance This value is the name of the transaction, TaskEngine, or other process that last updated this row. WhoColumns Character 50 INSENSITIVE N Y N Y 25 @ @ Last updating process |Last updating process N 200060 @ Y DB2 LST_UPDTNG_PRCSS EnterpriseDB last_updating_process MSSQL LAST_UPDATING_PROCESS MySQL LAST_UPDATING_PROCESS Oracle LAST_UPDATING_PROCESS Sybase LAST_UPDATING_PROCESS SV DBSignature SYSTEMVARIABLE DepartmentID 100 Unique DepartmentID UNIQUE 110 DepartmentID Name 200 Unique Name UNIQUE 210 Name DB2 SHRR_DPRTMNT SuperHRApplication AP EnterpriseDB shrr_department SuperHRApplication AP MSSQL SHRR_DEPARTMENT SuperHRApplication AP MySQL shrr_department SuperHRApplication AP Oracle SHRR_DEPARTMENT SuperHRApplication AP Sybase SHRR_DEPARTMENT SuperHRApplication AP OfficeLocation PT A location is a place at which your company does business. N Y OfficeLocationID SurrogateKey Office location Surrogate key for this table This value is the system-generated SurrogateKey for this table. Its value is 1 for the first row, increasing by 1 for each new row. This assures that each row's value is unique and therefore suitable for a primary key value. SurrogateKey Number 22 0 N Y Y N 10 #,##0 #,##0 Office location |Office location Y 10 #,##0 Y DB2 OFFICE_LOCATION_ID EnterpriseDB office_location_id MSSQL OFFICE_LOCATION_ID MySQL OFFICE_LOCATION_ID Oracle OFFICE_LOCATION_ID Sybase OFFICE_LOCATION_ID SQ OfficeLocation SEQUENCE Name HRName Name Enter the unique name This is the full name of this person or company. Location Character 50 INSENSITIVE Y Y Y Y 25 @ @ 1 Name |Name Y 20 @ N DB2 NAME EnterpriseDB name MSSQL NAME MySQL NAME Oracle NAME Sybase NAME PhoneNumber HRPhoneNumber Main phone number Enter the telephone number in the form 999/999-9999 Enter the telephone number in the form 999/999-9999. Location Character 15 INSENSITIVE Y Y N Y 25 @ @ Main phone number Main phone number Y 30 @ N DB2 PHONE_NUMBER EnterpriseDB phone_number MSSQL PHONE_NUMBER MySQL PHONE_NUMBER Oracle PHONE_NUMBER Sybase PHONE_NUMBER Extension HRPhoneExtension Main extension Enter the optional extension number for this telephone Enter the optional extension number for this telephone. Location Character 6 INSENSITIVE Y Y N Y 25 @ @ Main extension Main extension Y 40 @ N DB2 EXTENSION EnterpriseDB extension MSSQL EXTENSION MySQL EXTENSION Oracle EXTENSION Sybase EXTENSION FaxNumber HRFaxNumber Fax number Enter the fax number in the form 999/999-9999 Enter the fax number in the form 999/999-9999. Location Character 15 INSENSITIVE Y Y N Y 25 @ @ Fax number |Fax number Y 50 @ N DB2 FAX_NUMBER EnterpriseDB fax_number MSSQL FAX_NUMBER MySQL FAX_NUMBER Oracle FAX_NUMBER Sybase FAX_NUMBER AddressLine1 HRAddressLine1 Address Enter the address line, including floor or suite if applicable Enter the address line, including floor or suite if applicable. Location Character 40 INSENSITIVE Y Y N Y 25 @ @ Address Address Y 60 @ N DB2 ADDRESS_LINE1 EnterpriseDB address_line1 MSSQL ADDRESS_LINE1 MySQL ADDRESS_LINE1 Oracle ADDRESS_LINE1 Sybase ADDRESS_LINE1 AddressLine2 HRAddressLine2 Line 2 Enter the address line, including floor or suite if applicable Enter the address line, including floor or suite if applicable. Location Character 40 INSENSITIVE Y Y N Y 25 @ @ Line 2 Line 2 Y 70 @ N DB2 ADDRESS_LINE2 EnterpriseDB address_line2 MSSQL ADDRESS_LINE2 MySQL ADDRESS_LINE2 Oracle ADDRESS_LINE2 Sybase ADDRESS_LINE2 City HRCity City The name of the city for this address The name of the city for this address. Location Character 30 INSENSITIVE Y Y N Y 25 @ @ City |City Y 80 @ N DB2 CITY EnterpriseDB city MSSQL CITY MySQL CITY Oracle CITY Sybase CITY StateCode HRStateCode State The state for this address The state for this address. Location Character 2 INSENSITIVE N Y Y Y 25 @ @ State |State Y 90 @ N DB2 STATE_CODE EnterpriseDB state_code MSSQL STATE_CODE MySQL STATE_CODE Oracle STATE_CODE Sybase STATE_CODE ZipCode HRZipCode Zip Enter the Zip code in the form 99999 or 99999-9999 Enter the Zip code in the form 99999 or 99999-9999. Location Character 10 INSENSITIVE Y Y N Y 25 @ @ Zip |Zip Y 100 @ N DB2 ZIP_CODE EnterpriseDB zip_code MSSQL ZIP_CODE MySQL ZIP_CODE Oracle ZIP_CODE Sybase ZIP_CODE CountryCode HRCountryCode Country Pick a country for this address Pick a country for this address. Location Character 2 INSENSITIVE N Y Y Y 25 @ @ Country |Country Y 110 @ N DB2 COUNTRY_CODE EnterpriseDB country_code MSSQL COUNTRY_CODE MySQL COUNTRY_CODE Oracle COUNTRY_CODE Sybase COUNTRY_CODE CreationDateTime CreationDateTime Creation date and time The date and time that this instance was created This value represent the full date and time that this table row was created. WhoColumns DateTime 19 N Y Y N 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Creation date time |Creation date time N 200020 MM/DD/YYYY HH24:MI:SS Y DB2 CREATION_DATE_TIME EnterpriseDB creation_date_time MSSQL CREATION_DATE_TIME MySQL CREATION_DATE_TIME Oracle CREATION_DATE_TIME Sybase CREATION_DATE_TIME SV DBToday SYSTEMVARIABLE CreatedBy CreatedBy Created by The person who created this instance This value represent the end-user who created this table row. WhoColumns Number 22 0 N Y Y N 10 #,##0 #,##0 Created by |Created by N 200030 #,##0 Y DB2 CREATED_BY EnterpriseDB created_by MSSQL CREATED_BY MySQL CREATED_BY Oracle CREATED_BY Sybase CREATED_BY SV EndUserID SYSTEMVARIABLE LastUpdateDateTime LastUpdateDateTime Last update date and time The date and time that this instance was last updated This value represents the date and time when this table row was most recently updated. WhoColumns DateTime 19 N Y Y Y 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Last update date time |Last update date time N 200040 MM/DD/YYYY HH24:MI:SS Y DB2 LST_UPDT_DT_TM EnterpriseDB last_update_date_time MSSQL LAST_UPDATE_DATE_TIME MySQL LAST_UPDATE_DATE_TIME Oracle LAST_UPDATE_DATE_TIME Sybase LAST_UPDATE_DATE_TIME SV DBToday SYSTEMVARIABLE LastUpdatedBy LastUpdatedBy Last updated by The person who last updated this instance This value represent the end-user who most recently updated this table row. WhoColumns Number 22 0 N Y Y Y 10 #,##0 #,##0 Last updated by |Last updated by N 200050 #,##0 Y DB2 LAST_UPDATED_BY EnterpriseDB last_updated_by MSSQL LAST_UPDATED_BY MySQL LAST_UPDATED_BY Oracle LAST_UPDATED_BY Sybase LAST_UPDATED_BY SV EndUserID SYSTEMVARIABLE LastUpdatingProcess LastUpdatingProcess Last updating process The name of the transaction, TaskEngine, et cetera that last updated this instance This value is the name of the transaction, TaskEngine, or other process that last updated this row. WhoColumns Character 50 INSENSITIVE N Y N Y 25 @ @ Last updating process |Last updating process N 200060 @ Y DB2 LST_UPDTNG_PRCSS EnterpriseDB last_updating_process MSSQL LAST_UPDATING_PROCESS MySQL LAST_UPDATING_PROCESS Oracle LAST_UPDATING_PROCESS Sybase LAST_UPDATING_PROCESS SV DBSignature SYSTEMVARIABLE OfficeLocationID 100 Unique OfficeLocationID UNIQUE 110 OfficeLocationID Name 200 Unique Name UNIQUE 210 Name DB2 SHRR_OFFC_LCTN SuperHRApplication AP EnterpriseDB shrr_office_location SuperHRApplication AP MSSQL SHRR_OFFICE_LOCATION SuperHRApplication AP MySQL shrr_office_location SuperHRApplication AP Oracle SHRR_OFFICE_LOCATION SuperHRApplication AP Sybase SHRR_OFFICE_LOCATION SuperHRApplication AP Organization PT An organization is a company, government agency, or educational institution that provided experience or education to employees. N Y OrganizationID SurrogateKey Organization Surrogate key for this table This value is the system-generated SurrogateKey for this table. Its value is 1 for the first row, increasing by 1 for each new row. This assures that each row's value is unique and therefore suitable for a primary key value. SurrogateKey Number 22 0 N Y Y N 10 #,##0 #,##0 Organization |Organization Y 10 #,##0 Y DB2 ORGANIZATION_ID EnterpriseDB organization_id MSSQL ORGANIZATION_ID MySQL ORGANIZATION_ID Oracle ORGANIZATION_ID Sybase ORGANIZATION_ID SQ Organization SEQUENCE Name HRName Name Enter the unique name Enter the unique name. Organization Character 50 INSENSITIVE Y Y Y Y 25 @ @ 1 Name |Name Y 20 @ N DB2 NAME EnterpriseDB name MSSQL NAME MySQL NAME Oracle NAME Sybase NAME OrganizationTypeCode OrganizationTypeCode Organization type Pick the type of organization Pick the type of organization. Organization Character 2 INSENSITIVE N Y Y Y 15 @ @ Organization type |Organization type Y 30 @ N DB2 ORG_TYPE_CODE EnterpriseDB organization_type_code MSSQL ORGANIZATION_TYPE_CODE MySQL ORGANIZATION_TYPE_CODE Oracle ORGANIZATION_TYPE_CODE Sybase ORGANIZATION_TYPE_CODE Description HRDescription Description Enter a brief description of this institution Enter a brief description of this institution. Organization Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 40 @ N DB2 DESCRIPTION EnterpriseDB description MSSQL DESCRIPTION MySQL DESCRIPTION Oracle DESCRIPTION Sybase DESCRIPTION WebSite HRWebSite Web site Enter the organization's web-site address Enter the organization's web-site address. Web site Character 100 INSENSITIVE Y Y N Y 25 @ @ Web site |Web site Y 50 @ N DB2 WEB_SITE EnterpriseDB web_site MSSQL WEB_SITE MySQL WEB_SITE Oracle WEB_SITE Sybase WEB_SITE InstitutionTypeCode InstitutionTypeCode Institution type Pick the type of educational institution Pick the type of educational institution. Educational institution Character 2 INSENSITIVE N Y N Y 15 @ @ Institution type |Institution type Y 60 @ N DB2 INSTTTN_TYP_CODE EnterpriseDB institution_type_code MSSQL INSTITUTION_TYPE_CODE MySQL INSTITUTION_TYPE_CODE Oracle INSTITUTION_TYPE_CODE Sybase INSTITUTION_TYPE_CODE CreationDateTime CreationDateTime Creation date and time The date and time that this instance was created This value represent the full date and time that this table row was created. WhoColumns DateTime 19 N Y Y N 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Creation date time |Creation date time N 200020 MM/DD/YYYY HH24:MI:SS Y DB2 CREATION_DATE_TIME EnterpriseDB creation_date_time MSSQL CREATION_DATE_TIME MySQL CREATION_DATE_TIME Oracle CREATION_DATE_TIME Sybase CREATION_DATE_TIME SV DBToday SYSTEMVARIABLE CreatedBy CreatedBy Created by The person who created this instance This value represent the end-user who created this table row. WhoColumns Number 22 0 N Y Y N 10 #,##0 #,##0 Created by |Created by N 200030 #,##0 Y DB2 CREATED_BY EnterpriseDB created_by MSSQL CREATED_BY MySQL CREATED_BY Oracle CREATED_BY Sybase CREATED_BY SV EndUserID SYSTEMVARIABLE LastUpdateDateTime LastUpdateDateTime Last update date and time The date and time that this instance was last updated This value represents the date and time when this table row was most recently updated. WhoColumns DateTime 19 N Y Y Y 13 MM/DD/YYYY HH24:MI:SS MM/DD/YYYY HH24:MI:SS Last update date time |Last update date time N 200040 MM/DD/YYYY HH24:MI:SS Y DB2 LST_UPDT_DT_TM EnterpriseDB last_update_date_time MSSQL LAST_UPDATE_DATE_TIME MySQL LAST_UPDATE_DATE_TIME Oracle LAST_UPDATE_DATE_TIME Sybase LAST_UPDATE_DATE_TIME SV DBToday SYSTEMVARIABLE LastUpdatedBy LastUpdatedBy Last updated by The person who last updated this instance This value represent the end-user who most recently updated this table row. WhoColumns Number 22 0 N Y Y Y 10 #,##0 #,##0 Last updated by |Last updated by N 200050 #,##0 Y DB2 LAST_UPDATED_BY EnterpriseDB last_updated_by MSSQL LAST_UPDATED_BY MySQL LAST_UPDATED_BY Oracle LAST_UPDATED_BY Sybase LAST_UPDATED_BY SV EndUserID SYSTEMVARIABLE LastUpdatingProcess LastUpdatingProcess Last updating process The name of the transaction, TaskEngine, et cetera that last updated this instance This value is the name of the transaction, TaskEngine, or other process that last updated this row. WhoColumns Character 50 INSENSITIVE N Y N Y 25 @ @ Last updating process |Last updating process N 200060 @ Y DB2 LST_UPDTNG_PRCSS EnterpriseDB last_updating_process MSSQL LAST_UPDATING_PROCESS MySQL LAST_UPDATING_PROCESS Oracle LAST_UPDATING_PROCESS Sybase LAST_UPDATING_PROCESS SV DBSignature SYSTEMVARIABLE OrganizationID 100 Unique OrganizationID UNIQUE 110 OrganizationID Name 200 Unique Name UNIQUE 210 Name DB2 SHRR_ORG SuperHRApplication AP EnterpriseDB shrr_organization SuperHRApplication AP MSSQL SHRR_ORGANIZATION SuperHRApplication AP MySQL shrr_organization SuperHRApplication AP Oracle SHRR_ORGANIZATION SuperHRApplication AP Sybase SHRR_ORGANIZATION SuperHRApplication AP Employees 0 The Employees database includes tables that manage an employee and track employee details. Assignment PT Add or edit assignments of an employee to a department. N Y AssignmentID SurrogateKey Assignment Surrogate key for this table This value is the system-generated SurrogateKey for this table. Its value is 1 for the first row, increasing by 1 for each new row. This assures that each row's value is unique and therefore suitable for a primary key value. SurrogateKey Number 22 0 N Y Y N 10 #,##0 #,##0 Assignment |Assignment Y 100 #,##0 Y DB2 ASSIGNMENT_ID EnterpriseDB assignment_id MSSQL ASSIGNMENT_ID MySQL ASSIGNMENT_ID Oracle ASSIGNMENT_ID Sybase ASSIGNMENT_ID SQ Assignment SEQUENCE StaffMemberID StaffMemberID Staff member Pick an employee or other staff member Pick an employee or other staff member. Staff member Number 22 0 N Y Y Y 10 #,##0 #,##0 1 Staff member |Staff member Y 110 #,##0 N DB2 STAFF_MEMBER_ID EnterpriseDB staff_member_id MSSQL STAFF_MEMBER_ID MySQL STAFF_MEMBER_ID Oracle STAFF_MEMBER_ID Sybase STAFF_MEMBER_ID ManagerID StaffMemberID Manager Pick an employee or other staff member Pick an employee or other staff member. Assignment Number 22 0 N Y N Y 10 #,##0 #,##0 Manager |Manager Y 120 #,##0 N DB2 MANAGER_ID EnterpriseDB manager_id MSSQL MANAGER_ID MySQL MANAGER_ID