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 Oracle MANAGER_ID Sybase MANAGER_ID StartDate HRStartDate Start date Enter the date that this assignment starts Enter the date that this assignment starts. Assignment Date 10 Y Y Y Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING Start date |Start date Y 130 MM/DD/YYYY N DB2 START_DATE EnterpriseDB start_date MSSQL START_DATE MySQL START_DATE Oracle START_DATE Sybase START_DATE EndDate HREndDate End date Enter the date that this assignment ends Enter the date that this assignment ends. Assignment Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY End date |End date Y 140 MM/DD/YYYY N DB2 END_DATE EnterpriseDB end_date MSSQL END_DATE MySQL END_DATE Oracle END_DATE Sybase END_DATE AssignmentStatusCode AssignmentStatusCode Assignment status Pick the current status of an employee's assignment Pick the current status of an employee's assignment. Assignment Character 2 INSENSITIVE N Y Y Y 25 @ @ Assignment status |Assignment status Y 150 @ N DB2 ASSGNMNT_STTS_CODE EnterpriseDB assignment_status_code MSSQL ASSIGNMENT_STATUS_CODE MySQL ASSIGNMENT_STATUS_CODE Oracle ASSIGNMENT_STATUS_CODE Sybase ASSIGNMENT_STATUS_CODE DepartmentID DepartmentID Department Pick the department in your company Pick the department in your company. Assignment Number 22 0 N Y N Y 10 #,##0 #,##0 Department |Department Y 160 #,##0 N DB2 DEPARTMENT_ID EnterpriseDB department_id MSSQL DEPARTMENT_ID MySQL DEPARTMENT_ID Oracle DEPARTMENT_ID Sybase DEPARTMENT_ID Description HRDescription Description Enter a brief description of this employee's assignment Enter a brief description of this employee's assignment. Assignment Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 170 @ N DB2 DESCRIPTION EnterpriseDB description MSSQL DESCRIPTION MySQL DESCRIPTION Oracle DESCRIPTION Sybase DESCRIPTION ActiveFlag Checkbox Active Check Yes if this assigment is active Check Yes if this assigment is active. Assignment Character 1 UPPER Y CHECKBOX Y N Y 1 @ @ Active |Active Y 180 @ N DB2 ACTIVE_FLAG EnterpriseDB active_flag MSSQL ACTIVE_FLAG MySQL ACTIVE_FLAG Oracle ACTIVE_FLAG Sybase ACTIVE_FLAG 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 AssignmentID 100 Unique AssignmentID UNIQUE 110 AssignmentID UniqueKey 500 Unique UniqueKey UNIQUE 1 StaffMemberID 2 ManagerID 3 StartDate DB2 SHRR_ASSGNMNT SuperHRApplication AP EnterpriseDB shrr_assignment SuperHRApplication AP MSSQL SHRR_ASSIGNMENT SuperHRApplication AP MySQL shrr_assignment SuperHRApplication AP Oracle SHRR_ASSIGNMENT SuperHRApplication AP Sybase SHRR_ASSIGNMENT SuperHRApplication AP Award PT Add or edit an award or honor earned by an employee. N Y AwardID SurrogateKey Award 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 Award |Award Y 10 #,##0 Y DB2 AWARD_ID EnterpriseDB award_id MSSQL AWARD_ID MySQL AWARD_ID Oracle AWARD_ID Sybase AWARD_ID SQ Award 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 ASCENDING Staff member |Staff member Y 20 #,##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 AwardTypeCode AwardTypeCode Award type Pick the type of honor or award earned by an employee Pick the type of honor or award earned by an employee. Award Character 2 INSENSITIVE N Y Y Y 25 @ @ Award type |Award type Y 30 @ N DB2 AWARD_TYPE_CODE EnterpriseDB award_type_code MSSQL AWARD_TYPE_CODE MySQL AWARD_TYPE_CODE Oracle AWARD_TYPE_CODE Sybase AWARD_TYPE_CODE AwardDate HRPastDate Award date Enter the date of the employee's award Enter the date of the employee's award. Award Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING Award date |Award date Y 40 MM/DD/YYYY N DB2 AWARD_DATE EnterpriseDB award_date MSSQL AWARD_DATE MySQL AWARD_DATE Oracle AWARD_DATE Sybase AWARD_DATE Description HRDescription Description Enter a description of this award Enter a description of this award. Award Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 50 @ 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 AwardID 100 Unique AwardID UNIQUE 110 AwardID UniqueKey 400 Unique UniqueKey UNIQUE 1 StaffMemberID 2 AwardTypeCode 3 AwardDate DB2 SHRR_AWARD SuperHRApplication AP EnterpriseDB shrr_award SuperHRApplication AP MSSQL SHRR_AWARD SuperHRApplication AP MySQL shrr_award SuperHRApplication AP Oracle SHRR_AWARD SuperHRApplication AP Sybase SHRR_AWARD SuperHRApplication AP Certification PT Add or edit a skill certification for an employee. N Y CertificationID SurrogateKey Certification 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 Certification |Certification Y 10 #,##0 Y DB2 CERTIFICATION_ID EnterpriseDB certification_id MSSQL CERTIFICATION_ID MySQL CERTIFICATION_ID Oracle CERTIFICATION_ID Sybase CERTIFICATION_ID SQ Certification 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 20 #,##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 CertificationTypeCode CertificationTypeCode Certification type Pick the type of certification for an employee Pick the type of certification for an employee. Certification Character 2 INSENSITIVE N Y Y Y 25 @ @ Certification type |Certification type Y 30 @ N DB2 CRTFCTN_TYP_CODE EnterpriseDB certification_type_code MSSQL CERTIFICATION_TYPE_CODE MySQL CERTIFICATION_TYPE_CODE Oracle CERTIFICATION_TYPE_CODE Sybase CERTIFICATION_TYPE_CODE CertifyingAgency HRNonUniqueName Certifying agency Enter the name of the agency that certified this employee Enter the name of the agency that certified this employee. Certification Character 50 INSENSITIVE Y Y Y Y 25 @ @ Certifying agency |Certifying agency Y 40 @ N DB2 CERTIFYING_AGENCY EnterpriseDB certifying_agency MSSQL CERTIFYING_AGENCY MySQL CERTIFYING_AGENCY Oracle CERTIFYING_AGENCY Sybase CERTIFYING_AGENCY CertificationDate HRPastDate Certification date Enter the date this employee's certification took effect Enter the date this employee's certification took effect. Certification Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING Certification date |Certification date Y 50 MM/DD/YYYY N DB2 CERTIFICATION_DATE EnterpriseDB certification_date MSSQL CERTIFICATION_DATE MySQL CERTIFICATION_DATE Oracle CERTIFICATION_DATE Sybase CERTIFICATION_DATE ExpirationDate HRExpirationDate Expiration date Enter the date that this employee's certification expires Enter the date that this employee's certification expires. Certification Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY Expiration date |Expiration date Y 60 MM/DD/YYYY N DB2 EXPIRATION_DATE EnterpriseDB expiration_date MSSQL EXPIRATION_DATE MySQL EXPIRATION_DATE Oracle EXPIRATION_DATE Sybase EXPIRATION_DATE Description HRDescription Description Enter a brief description of this certification Enter a brief description of this certification. Certification Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 70 @ 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 CertificationID 100 Unique CertificationID UNIQUE 110 CertificationID UniqueKey 400 Unique UniqueKey UNIQUE 1 StaffMemberID 2 CertificationTypeCode 3 CertifyingAgency 4 CertificationDate DB2 SHRR_CRTFCTN SuperHRApplication AP EnterpriseDB shrr_certification SuperHRApplication AP MSSQL SHRR_CERTIFICATION SuperHRApplication AP MySQL shrr_certification SuperHRApplication AP Oracle SHRR_CERTIFICATION SuperHRApplication AP Sybase SHRR_CERTIFICATION SuperHRApplication AP Compensation PT Add or edit compensation, such as salary or stock option, for an employee. N Y CompensationID SurrogateKey Compensation 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 Compensation |Compensation Y 10 #,##0 Y DB2 COMPENSATION_ID EnterpriseDB compensation_id MSSQL COMPENSATION_ID MySQL COMPENSATION_ID Oracle COMPENSATION_ID Sybase COMPENSATION_ID SQ Compensation 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 20 #,##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 CompensationTypeCode CompensationTypeCode Compensation type Pick the type of compensation you pay to an employee Pick the type of compensation you pay to an employee. Compensation Character 2 INSENSITIVE N Y Y Y 25 @ @ 3 ASCENDING Compensation type |Compensation type Y 30 @ N DB2 CMPNSTN_TYP_CODE EnterpriseDB compensation_type_code MSSQL COMPENSATION_TYPE_CODE MySQL COMPENSATION_TYPE_CODE Oracle COMPENSATION_TYPE_CODE Sybase COMPENSATION_TYPE_CODE StartDate HRStartDate Start date Enter the date that this compensation starts Enter the date that this compensation starts. Compensation Date 10 Y Y Y Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING Start date |Start date Y 40 MM/DD/YYYY N DB2 START_DATE EnterpriseDB start_date MSSQL START_DATE MySQL START_DATE Oracle START_DATE Sybase START_DATE EndDate HREndDate End date Enter the date that this compensation ends Enter the date that this compensation ends. Compensation Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY End date |End date Y 50 MM/DD/YYYY N DB2 END_DATE EnterpriseDB end_date MSSQL END_DATE MySQL END_DATE Oracle END_DATE Sybase END_DATE CompensationAmount HRCurrencyAmount Compensation amount Enter the compensation amount Enter the compensation amount. Compensation Number 22 2 Y Y N Y 10 $#,##0.00 $#,##0.00 Compensation amount |Compensation amount Y 60 $#,##0.00 N DB2 CMPNSTN_AMNT EnterpriseDB compensation_amount MSSQL COMPENSATION_AMOUNT MySQL COMPENSATION_AMOUNT Oracle COMPENSATION_AMOUNT Sybase COMPENSATION_AMOUNT Description HRDescription Description Enter a brief description or comment about this compensation Enter a brief description or comment about this compensation. Compensation Character 240 INSENSITIVE Y Y N Y 25 @ @ Description |Description Y 70 @ 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 CompensationID 100 Unique CompensationID UNIQUE 110 CompensationID UniqueKey 400 Unique UniqueKey UNIQUE 1 StaffMemberID 2 CompensationTypeCode 3 StartDate DB2 SHRR_CMPNSTN SuperHRApplication AP EnterpriseDB shrr_compensation SuperHRApplication AP MSSQL SHRR_COMPENSATION SuperHRApplication AP MySQL shrr_compensation SuperHRApplication AP Oracle SHRR_COMPENSATION SuperHRApplication AP Sybase SHRR_COMPENSATION SuperHRApplication AP Competency PT Add or edit a skill or competency for an employee. N Y CompetencyID SurrogateKey Competency 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 Competency |Competency Y 10 #,##0 Y DB2 COMPETENCY_ID EnterpriseDB competency_id MSSQL COMPETENCY_ID MySQL COMPETENCY_ID Oracle COMPETENCY_ID Sybase COMPETENCY_ID SQ Competency 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 20 #,##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 CompetencyTypeCode CompetencyTypeCode Competency type Pick the type of skill or competency of an employee Pick the type of skill or competency of an employee. Competency Character 2 INSENSITIVE N Y Y Y 25 @ @ 2 ASCENDING Competency type |Competency type Y 30 @ N DB2 CMPTNCY_TYP_CODE EnterpriseDB competency_type_code MSSQL COMPETENCY_TYPE_CODE MySQL COMPETENCY_TYPE_CODE Oracle COMPETENCY_TYPE_CODE Sybase COMPETENCY_TYPE_CODE CompetencyLevelCode CompetencyLevelCode Competency level Pick the level of skill for a particular employee competency Pick the level of skill for a particular employee competency. Competency Character 2 INSENSITIVE N Y Y Y 25 @ @ Competency level |Competency level Y 40 @ N DB2 CMPTNCY_LVL_CODE EnterpriseDB competency_level_code MSSQL COMPETENCY_LEVEL_CODE MySQL COMPETENCY_LEVEL_CODE Oracle COMPETENCY_LEVEL_CODE Sybase COMPETENCY_LEVEL_CODE Description HRDescription Skill or knowledge Enter a brief description or comment on this competency Enter a brief description or comment on this competency. Competency Character 240 INSENSITIVE Y Y Y Y 25 @ @ Skill or knowledge Skill or knowledge Y 50 @ 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 CompetencyID 100 Unique CompetencyID UNIQUE 110 CompetencyID UniqueKey 500 Unique UniqueKey UNIQUE 1 StaffMemberID 2 CompetencyTypeCode 4 Description DB2 SHRR_CMPTNCY SuperHRApplication AP EnterpriseDB shrr_competency SuperHRApplication AP MSSQL SHRR_COMPETENCY SuperHRApplication AP MySQL shrr_competency SuperHRApplication AP Oracle SHRR_COMPETENCY SuperHRApplication AP Sybase SHRR_COMPETENCY SuperHRApplication AP Education PT Add or edit an educational achievement by an employee. N Y EducationID SurrogateKey Education 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 Education |Education Y 100 #,##0 Y DB2 EDUCATION_ID EnterpriseDB education_id MSSQL EDUCATION_ID MySQL EDUCATION_ID Oracle EDUCATION_ID Sybase EDUCATION_ID SQ Education 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 EducationLocationID OrganizationID Education location Pick a college or other institution that provided education to employees Pick a college or other institution that provided education to employees. Education Number 22 0 N Y Y Y 10 #,##0 #,##0 Education location |Education location Y 130 #,##0 N DB2 EDCTN_LCTN_ID EnterpriseDB education_location_id MSSQL EDUCATION_LOCATION_ID MySQL EDUCATION_LOCATION_ID Oracle EDUCATION_LOCATION_ID Sybase EDUCATION_LOCATION_ID EducationLevelCode EducationLevelCode Education level Pick the education level achieved by an employee Pick the education level achieved by an employee. Education Character 2 INSENSITIVE N Y Y Y 25 @ @ Education level |Education level Y 140 @ N DB2 EDCTN_LVL_CODE EnterpriseDB education_level_code MSSQL EDUCATION_LEVEL_CODE MySQL EDUCATION_LEVEL_CODE Oracle EDUCATION_LEVEL_CODE Sybase EDUCATION_LEVEL_CODE FromDate HRPastDate From date Enter the start date for this education Enter the start date for this education. Education Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING From date |From date Y 150 MM/DD/YYYY N DB2 FROM_DATE EnterpriseDB from_date MSSQL FROM_DATE MySQL FROM_DATE Oracle FROM_DATE Sybase FROM_DATE ToDate Date To date Enter the end date for this education Enter the end date for this education. Education Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY To date |To date Y 160 MM/DD/YYYY N DB2 TO_DATE EnterpriseDB to_date MSSQL TO_DATE MySQL TO_DATE Oracle TO_DATE Sybase TO_DATE CompletedFlag Checkbox Completed Check Yes if the employee completed this education Check Yes if the employee completed this education. Education Character 1 UPPER Y CHECKBOX Y N Y 1 @ @ Completed |Completed Y 170 @ N DB2 COMPLETED_FLAG EnterpriseDB completed_flag MSSQL COMPLETED_FLAG MySQL COMPLETED_FLAG Oracle COMPLETED_FLAG Sybase COMPLETED_FLAG Description HRDescription Degree Enter a brief description or comment on this degree and education experience Enter a brief description or comment on this degree and education experience. Education Character 240 INSENSITIVE Y Y N Y 25 @ @ Degree Degree Y 180 @ 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 EducationID 100 Unique EducationID UNIQUE 110 EducationID UniqueKey 900 Unique UniqueKey UNIQUE 1 StaffMemberID 2 EducationLocationID 3 EducationLevelCode DB2 SHRR_EDUCATION SuperHRApplication AP EnterpriseDB shrr_education SuperHRApplication AP MSSQL SHRR_EDUCATION SuperHRApplication AP MySQL shrr_education SuperHRApplication AP Oracle SHRR_EDUCATION SuperHRApplication AP Sybase SHRR_EDUCATION SuperHRApplication AP EmergencyContact PT Add or edit person to contact in the event of an emergency of an employee. N Y EmergencyContactID SurrogateKey Emergency contact 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 Emergency contact |Emergency contact Y 10 #,##0 Y DB2 EMRGNCY_CNTCT_ID EnterpriseDB emergency_contact_id MSSQL EMERGENCY_CONTACT_ID MySQL EMERGENCY_CONTACT_ID Oracle EMERGENCY_CONTACT_ID Sybase EMERGENCY_CONTACT_ID SQ EmergencyContact 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 20 #,##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 Name HRNonUniqueName Name Enter the unique name Enter the unique name. Contact Character 50 INSENSITIVE Y Y Y Y 25 @ @ Name |Name Y 30 @ N DB2 NAME EnterpriseDB name MSSQL NAME MySQL NAME Oracle NAME Sybase NAME PriorityOrder Number Priority order Enter the priority of this contact (1=primary contact, 2=secondary,...) Enter the priority of this contact (1=primary contact, 2=secondary,...). Contact Number 22 0 Y Y N Y 10 #,##0 #,##0 2 ASCENDING Priority order |Priority order Y 40 #,##0 N DB2 PRIORITY_ORDER EnterpriseDB priority_order MSSQL PRIORITY_ORDER MySQL PRIORITY_ORDER Oracle PRIORITY_ORDER Sybase PRIORITY_ORDER RelationshipCode RelationshipCode Relationship Pick the relationship of an individual to an employee Pick the relationship of an individual to an employee. Contact Character 2 INSENSITIVE N Y Y Y 25 @ @ Relationship |Relationship Y 50 @ N DB2 RELATIONSHIP_CODE EnterpriseDB relationship_code MSSQL RELATIONSHIP_CODE MySQL RELATIONSHIP_CODE Oracle RELATIONSHIP_CODE Sybase RELATIONSHIP_CODE Description HRDescription Description Enter a brief description or comment about this emergency contact Enter a brief description or comment about this emergency contact. Contact 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 PhoneNumber HRPhoneNumber Phone number Enter the telephone number in the form 999/999-9999 Enter the telephone number in the form 999/999-9999. Contact details Character 15 INSENSITIVE Y Y N Y 25 @ @ Phone number |Phone number Y 70 @ N DB2 PHONE_NUMBER EnterpriseDB phone_number MSSQL PHONE_NUMBER MySQL PHONE_NUMBER Oracle PHONE_NUMBER Sybase PHONE_NUMBER FAXNumber HRFaxNumber FAX number Enter the fax number in the form 999/999-9999 Enter the fax number in the form 999/999-9999. Contact details Character 15 INSENSITIVE Y Y N Y 25 @ @ FAX number |FAX number Y 80 @ N DB2 FAX_NUMBER EnterpriseDB fax_number MSSQL FAX_NUMBER MySQL FAX_NUMBER Oracle FAX_NUMBER Sybase FAX_NUMBER EMailAddress HREMailAddress E-mail address Enter an e-mail address of the form xxx@yyy Enter an e-mail address of the form xxx@yyy. Contact details Character 50 INSENSITIVE Y Y N Y 25 @ @ E-mail address E-mail address Y 90 @ N DB2 E_MAIL_ADDRESS EnterpriseDB e_mail_address MSSQL E_MAIL_ADDRESS MySQL E_MAIL_ADDRESS Oracle E_MAIL_ADDRESS Sybase E_MAIL_ADDRESS AddressLine1 HRAddressLine1 Address Enter the address line, including floor or suite if applicable Enter the address line, including floor or suite if applicable. Contact details Character 40 INSENSITIVE Y Y N Y 25 @ @ Address Address Y 100 @ 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. Contact details Character 40 INSENSITIVE Y Y N Y 25 @ @ Line 2 Line 2 Y 110 @ 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. Contact details Character 30 INSENSITIVE Y Y N Y 25 @ @ City |City Y 120 @ 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. Contact details Character 2 INSENSITIVE N Y Y Y 25 @ @ State |State Y 130 @ 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. Contact details Character 10 INSENSITIVE Y Y N Y 25 @ @ Zip |Zip Y 140 @ 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. Contact details Character 2 INSENSITIVE N Y Y Y 25 @ @ Country |Country Y 150 @ 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 EmergencyContactID 100 Unique EmergencyContactID UNIQUE 110 EmergencyContactID UniqueKey 600 Unique UniqueKey UNIQUE 1 StaffMemberID 2 Name 4 RelationshipCode DB2 SHRR_EMRGNCY_C SuperHRApplication AP EnterpriseDB shrr_emergency_contact SuperHRApplication AP MSSQL SHRR_EMERGENCY_CONTACT SuperHRApplication AP MySQL shrr_emergency_contact SuperHRApplication AP Oracle SHRR_EMERGENCY_CONTACT SuperHRApplication AP Sybase SHRR_EMERGENCY_CONTACT SuperHRApplication AP EmployeeAddress PT Add or edit an address of an employee. N Y EmployeeAddressID SurrogateKey Employee address 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 Employee address |Employee address Y 350 #,##0 Y DB2 EMPLY_ADDRSS_ID EnterpriseDB employee_address_id MSSQL EMPLOYEE_ADDRESS_ID MySQL EMPLOYEE_ADDRESS_ID Oracle EMPLOYEE_ADDRESS_ID Sybase EMPLOYEE_ADDRESS_ID SQ EmployeeAddress 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 360 #,##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 Description HRDescription Description Enter a complete description Enter a complete description. Address Character 240 INSENSITIVE Y Y Y Y 25 @ @ 2 ASCENDING Description |Description Y 370 @ N DB2 DESCRIPTION EnterpriseDB description MSSQL DESCRIPTION MySQL DESCRIPTION Oracle DESCRIPTION Sybase DESCRIPTION PriorityOrder Number Priority order Enter the priority order of this address (1=primary, 2=secondary, ...) Enter the priority order of this address (1=primary, 2=secondary, ...). Address Number 22 0 Y Y N Y 10 #,##0 #,##0 Priority order |Priority order Y 380 #,##0 N DB2 PRIORITY_ORDER EnterpriseDB priority_order MSSQL PRIORITY_ORDER MySQL PRIORITY_ORDER Oracle PRIORITY_ORDER Sybase PRIORITY_ORDER PhoneNumber HRPhoneNumber Phone number Enter the telephone number in the form 999/999-9999 Enter the telephone number in the form 999/999-9999. Address Character 15 INSENSITIVE Y Y N Y 25 @ @ Phone number |Phone number Y 390 @ N DB2 PHONE_NUMBER EnterpriseDB phone_number MSSQL PHONE_NUMBER MySQL PHONE_NUMBER Oracle PHONE_NUMBER Sybase PHONE_NUMBER FAXNumber HRFaxNumber FAX number Enter the fax number in the form 999/999-9999 Enter the fax number in the form 999/999-9999. Address Character 15 INSENSITIVE Y Y N Y 25 @ @ FAX number |FAX number Y 400 @ 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. Address Character 40 INSENSITIVE Y Y N Y 25 @ @ Address Address Y 410 @ 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 second address line, if any Enter the second address line, if any. Address Character 40 INSENSITIVE Y Y N Y 25 @ @ Line 2 Line 2 Y 420 @ 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. Address Character 30 INSENSITIVE Y Y N Y 25 @ @ City |City Y 430 @ 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. Address Character 2 INSENSITIVE N Y Y Y 25 @ @ State |State Y 440 @ 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. Address Character 10 INSENSITIVE Y Y N Y 25 @ @ Zip |Zip Y 450 @ 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. Address Character 2 INSENSITIVE N Y Y Y 25 @ @ Country |Country Y 460 @ 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 EmployeeAddressID 100 Unique EmployeeAddressID UNIQUE 110 EmployeeAddressID UniqueKey 500 Unique UniqueKey UNIQUE 1 StaffMemberID 2 Description DB2 SHRR_EMPLY_ADD SuperHRApplication AP EnterpriseDB shrr_employee_address SuperHRApplication AP MSSQL SHRR_EMPLOYEE_ADDRESS SuperHRApplication AP MySQL shrr_employee_address SuperHRApplication AP Oracle SHRR_EMPLOYEE_ADDRESS SuperHRApplication AP Sybase SHRR_EMPLOYEE_ADDRESS SuperHRApplication AP EmployeeNote PT Add or edit a note about an employee. N Y EmployeeNoteID SurrogateKey Employee note 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 Employee note |Employee note Y 10 #,##0 Y DB2 EMPLOYEE_NOTE_ID EnterpriseDB employee_note_id MSSQL EMPLOYEE_NOTE_ID MySQL EMPLOYEE_NOTE_ID Oracle EMPLOYEE_NOTE_ID Sybase EMPLOYEE_NOTE_ID SQ EmployeeNote 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 20 #,##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 EmployeeNoteTypeCode EmployeeNoteTypeCode Employee note type Pick the type of note about an employee Pick the type of note about an employee. Note Character 2 INSENSITIVE N Y Y Y 25 @ @ Employee note type |Employee note type Y 30 @ N DB2 EMPLY_NT_TYP_CODE EnterpriseDB employee_note_type_code MSSQL EMPLOYEE_NOTE_TYPE_CODE MySQL EMPLOYEE_NOTE_TYPE_CODE Oracle EMPLOYEE_NOTE_TYPE_CODE Sybase EMPLOYEE_NOTE_TYPE_CODE Description HRDescription Description Enter a brief comment or description Enter a brief comment or description. Note 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 Attachment HRAttachment Attachment Enter or browse for the employee attachment, if any Enter or browse for the employee attachment, if any. Note Blob 10000000 Y LD Y N Y Attachment |Attachment Y 50 N DB2 ATTACHMENT EnterpriseDB attachment MSSQL ATTACHMENT MySQL ATTACHMENT Oracle ATTACHMENT Sybase ATTACHMENT 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 2 DESCENDING 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 EmployeeNoteID 100 Unique EmployeeNoteID UNIQUE 110 EmployeeNoteID UniqueKey 400 Unique UniqueKey UNIQUE 1 StaffMemberID 2 EmployeeNoteTypeCode 3 CreatedBy 4 CreationDateTime 5 Description DB2 SHRR_EMPLY_NT SuperHRApplication AP EnterpriseDB shrr_employee_note SuperHRApplication AP MSSQL SHRR_EMPLOYEE_NOTE SuperHRApplication AP MySQL shrr_employee_note SuperHRApplication AP Oracle SHRR_EMPLOYEE_NOTE SuperHRApplication AP Sybase SHRR_EMPLOYEE_NOTE SuperHRApplication AP Experience PT Add or edit information about an employee's experience. N Y ExperienceID SurrogateKey Experience 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 Experience |Experience Y 10 #,##0 Y DB2 EXPERIENCE_ID EnterpriseDB experience_id MSSQL EXPERIENCE_ID MySQL EXPERIENCE_ID Oracle EXPERIENCE_ID Sybase EXPERIENCE_ID SQ Experience 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 20 #,##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 FromDate HRStartDate From date Enter the date that this experience started Enter the date that this experienced started. Experience Date 10 Y Y Y Y 10 MM/DD/YYYY MM/DD/YYYY 2 DESCENDING From date |From date Y 30 MM/DD/YYYY N DB2 FROM_DATE EnterpriseDB from_date MSSQL FROM_DATE MySQL FROM_DATE Oracle FROM_DATE Sybase FROM_DATE ToDate HREndDate To date Enter the date that this experience ended Enter the date that this experience ended. Experience Date 10 Y Y N Y 10 MM/DD/YYYY MM/DD/YYYY To date |To date Y 40 MM/DD/YYYY N DB2 TO_DATE EnterpriseDB to_date MSSQL TO_DATE MySQL TO_DATE Oracle TO_DATE Sybase TO_DATE OrganizationName HRNonUniqueName Organization Enter the name of the organization with which the employee had experience Enter the name of the organization with which the employee had experience. Experience Character 50 INSENSITIVE Y Y Y Y 25 @ @ Organization Organization Y 50 @ N DB2 ORGANIZATION_NAME EnterpriseDB organization_name MSSQL ORGANIZATION_NAME MySQL ORGANIZATION_NAME Oracle ORGANIZATION_NAME Sybase ORGANIZATION_NAME Description HRText Description Enter a comprehensive explanation of this employee's experience Enter a comprehensive explanation of this employee's experience. Experience Character 1000000 INSENSITIVE Y MULTILINE_WRAP 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.