{{ model.title }}
This page is currently being edited by {{ model.editingBy }}.SmartFusion Modules > System Setup > Data Entry > System File > Relias Personnel Export
Recent Change:
6.241 - New ImplementationIntroduction
This screen will allow users to set up a job that will create a Relias Personnel Export based on the schedule set.
Requirements
A compatible version of SQL Server with SQL Server Agent functionality is required. Specifically, SQL Server Express is not supported.
File Layout
Detail Record
| Field | Data Type | Required Y/N | Comment |
|---|---|---|---|
| Entry type | char(4) | Y | hard coded to "USER" |
| OrgID | int | Y | Relias defined |
| OrgCode | varchar(6) | Y | Relias defined |
| Last Name | nvarchar(50) | Y | |
| First Name | nvarchar(50) | Y | |
| User Name | nvarchar(50) | Y | First initial + last name |
| Password | nvarchar(50) | Y | Defaulted to "welcome |
| GUID | nvarchar(50) | N | blank |
| Employee ID | nvarchar(50) | N | blank |
| Hire Date | smalldatetime | N | hire date or rehire date in YYYY-MM-DD hh:mm:ss format |
| Termination Date | smalldatetime | N | blank |
| nvarchar(150) | N | employee email address | |
| Job Title | nvarchar(100) | N | Class |
| Department | nvarchar(100) | N | blank |
| Orgnaization | nvarchar(100) | N | blank |
| Location | nvarchar(100) | N | Location |
| Work Phone | nvarchar(35) | N | blank |
| Credentials | nvarchar(25) | N | blank |
| Fax | nvarchar(25) | N | blank |
| Address | nvarchar(255) | N | Address1 |
| Address2 | nvarchar(255) | N | Address2 |
| City | nvarchar(255) | N | City |
| State | char(2) | N | State |
| Country | nvarchar(255) | N | blank |
| Postal Code | nvarchar(10) | N | Zip |
| Active | tinyint | Y | 0=if has a deactivation in personnel date, 1=if no deactivation in personnel date |
| HierarchyID | int | N | Category |
| UDF1 | int | N | blank |
| UDF2 | int | N | blank |
| UDF3 | int | N | blank |
| Restricted | tinyint | Y | 0 |
| User Categories | nvarchar(255) | N | blank |
| Hide From Master | int | N | blank |
| CanElect | int | N | blank |
| Self-Completion Mode | int | N | blank |
| External Request Mode | int | N | blank |
| Gender | char | N | blank |
| Ethnicity | nvarchar(50) | N | blank |
| Employment Types | nvarchar(100) | N | blank |
| Date of Birth | Datetime | N | DOB in YYYY-MM-DD hh:mm:ss format |
| Middle Name | nvarchar(50 | N | blank |
| Administrator | int | N | blank |
| Instructor | int | N | blank |
| Supervisor | char | N | blank |
| Observer | char | N | blank |
| Performance Optimzer Reporter | char | N | blank |
| Require Password Change on Next Login | int | N | blank |
| Exempt Status | int | N | blank |
| Additonal Hierarchy ID's | varchar(255) | N | blank |
| Comparison Group | int | N | blank |