Use these instructions to set up a new salaried or hourly employee.
When completing the Oracle forms referenced in this procedure, note that a white field indicates optional entry or one that is conditional based on the particular process.
Note: In addition to this process help, please refer to the following:
Complete the Effective Date fields:
Field Name |
Required (R) or Optional (O) |
Description |
Effective Date |
R |
Date for which the record is effective. Enter the person's original hire date. |
Field Name |
Required (R) or Optional (O) |
Description |
Last |
R |
Last name. |
First |
R |
First name. |
Title |
R |
Title. For example: Ms. |
Middle |
O |
Middle name or initial. |
Gender |
R |
Gender will default based on the Title field. If the title is Dr., select either Male or Female. |
Action |
R |
Select Create Employment from the drop down menu. |
Person Type for Action |
R |
System generated. |
Identification |
R |
System generated. |
Social Security |
R |
A nine-digit, unique personal identification number issued by the U.S. Social Security Administration. |
Field Name |
Required (R) or Optional (O) |
Description |
Birth Date |
R |
Date of birth. For example: 04-JUL-1970 |
Nationality |
R |
Citizenship data. Select from the List of Values: Non-Citizen in U.S. on VIsa Non-Citizen not in the U.S. Permanent Resident U.S. Citizen If a non-citizen in the U.S. on a Visa, complete the I-9 Expiration field on the People (Employment Information). Also complete the Non-Citizen Visa and Residency Info form and the Non-Citizen Reporting Info form in the Special Information Type. |
Registered Disability |
�" |
Do NOT use this field. For security reasons, the Research Foundation requires that this box not be checked . The appropriate information is not taken from this form. |
Field Name |
Required (R) or Optional (O) |
Description |
Ethnic Origin |
R |
Ethnic origin of individual. |
Veteran Status |
O |
Current veteran status. |
I-9 Status |
R |
I-9 document status. |
I-9 Expiration |
O |
Work authorization expiration date. For non-citizen employees in the U.S. on a Visa, enter the I-9 expiration date (i.e., the date of expiration for authorization to work in the U.S.). |
Field Name |
Required (R) or Optional (O) |
Description |
O |
E-mail address. |
|
Mailstop |
O |
Check delivery drop location. Checks are sorted by location, mailstop, and name. Mailstop information is defined by individual operating locations. See your campus administrator. |
Field Name |
Required (R) or Optional (O) |
Description |
E-Verify Status |
R |
Outcome of E-Verify system verification |
Date Authorized |
O |
Date employment authorization received |
Case Verification Number |
O |
Employee case verification number from E-Verify system |
SUNY Notification |
O |
If IFR on covered contract, was SUNY notified (Yes/No) |
Termination Date |
O |
System generated |
Field Name |
Required (R) or Optional (O) |
Description |
Address |
R |
Street address. |
City |
R |
City of Residence. |
State |
R |
State of Residence. |
Zip |
R |
Zip code. |
Telephone #1 |
O |
Telephone number. |
Type |
R |
Address type. Select from the List of Values. For example: Permanent |
Primary |
R |
Ensure that this box is checked. A primary U.S. address is required for everyone who is being processed through the Research Foundation payroll. |
Effective Dates Region |
R |
Date From is auto generated. Date To indicates the end date of the address. |
Field Name |
Required (R) or Optional (O) |
Description |
Style |
R |
Parameters of information by country. Choose the country whose style most reflects the foreign address information to include in the Address field from the List of Values. |
Field Name |
Required (R) or Optional (O) |
Description |
Type |
R |
Type of address. |
Primary |
R |
Do NOT check this box. When the Primary box is checked in step 11, ensure that this box is NOT checked. A primary U.S. address is required for everyone who is being processed through the Research Foundation payroll. |
Date From/ Date To |
R |
Effective dates of address. |
Field Name |
Required (R) or Optional (O) |
Description |
Campus Location |
R |
Chose campus location number from list of values |
Campus ID |
R |
Open field to enter campus identification number |
Field Name |
Required (R) or Optional (O) |
Description |
Original Hire Date |
R |
Date employee began working at the Research Foundation. |
Continuous Service Date |
R |
Enter the same date as the Original Hire Date for the new employee. |
Field Name |
Required (R) or Optional (O) |
Description |
Degree Expected |
R |
Type of degree. |
Expected Date |
R |
Actual or anticipated date of graduation. |
Field Name |
Required (R) or Optional (O) |
Description |
Education Level Reached |
R |
Highest level of education completed. |
Field Name |
Required (R) or Optional (O) |
Description |
Date Scheduled |
O |
The date the employee is scheduled to attend new employee orientation. |
Date Attended |
O |
Date the employee attended new employee orientation. |
Policy Received |
O |
Did the employee receive related policy documents, if applicable. Yes or No. |
Field Name |
Required (R) or Optional (O) |
Description |
Type of Cert/License |
R |
Type of license or certificate. |
Number |
R |
Number on the license or certificate. |
Date Issued |
R |
Date of the license or certificate. |
Date Expires |
R |
Expiration date of license or certificate. |
Current? |
R |
Indicates that the license or certificate is current. |
Additional Info |
O |
Any additional information. |
Field Name |
Required (R) or Optional (O) |
Description |
Visa Type |
R |
Visa type. |
Visa Number |
R |
Visa number. |
Res Alien for Tax - meets SPT |
R |
Indicates whether individual meets the requirements Substantial Presence Test and therefore is considered a Resident Alien for tax purposes. Y �" Yes N - No |
J Category Code |
R |
J category code. |
Primary Activity Code |
R |
Primary active code. |
Work Authorization Start Date |
R |
Work authorization start date. |
Country of Residence |
R |
Country of tax residence, not U.S. |
Country of Citizenship |
R |
Country of citizenship. |
Work Authorization Expiration Date |
R |
Date work authorization expires |
Married? |
R |
Indication of marital status. |
Spouse Here? |
R |
Indication of spouse living in the U.S. |
Number of Dependent Residents |
R |
Number of dependent residents. |
Passport Number |
R |
Passport number. |
Date First Entered US |
R |
Date first entered U.S. |
Date First Employee in US |
R |
Date first employed in U.S. |
Note: For foreign sourcing rules, please refer to the How to Determine Foreign Source Funding procedure.
Field Name |
Required (R) or Optional (O) |
Description |
Calendar Year |
R |
Calendar year. |
Income Code |
R |
Numeric representation of income. Select the applicable income code from the List of Values: 17- Dependent Personal Services 18- Teaching/Researching 19- Studying/Training |
Maximum Treaty Ben Amount |
R |
Maximum income tax treaty benefit amount. If no limit, leave this field blank. If treaty limit amount, enter amount. |
Treaty Benefits Allowed |
R |
Indicates whether treaty benefits are allowed. Select Y or N |
State Honors Treaty |
R |
Indicates whether the treaty is recognized by NYS state. NYS follows federal rules. Enter same as the Treaty Benefits Allowed field. |
Date Treaty Benefit Begins |
R |
Start date of treaty benefit. The start date is the date you enter exemption status to the tax information form in the system. Proof of exemption forms must be complete, valid, signed and dated. |
Date Treaty Benefit Ends |
R |
The end date is the date the treaty exemption stops. For example: For treaties valid for entire calendar year(s), enter 31-DEC-XX, where xx is the current calendar year. For treaties that cover multiple calendar years, the end date will have to be updated each year. For other treaties, enter the end date specified for that treaty based on the person�™s U.S. arrival date. |
Foreign Source? |
R |
Not applicable for Employees. |
Country of Tax Residence |
R |
Country of tax residence for the individual. Select treaty country assigned by government from the List of Values. |
Tax Rate |
R |
Select 00- No Tax from the List of Values for treaty exemption. |
Exemption Code |
R |
Select 4- Treaty Exempt from the List of Values. |
YTD 1042-S Fed With Amount |
�" |
Do not enter. This is system generated at year-end. |
YTD 1042-S State With Amount |
�" |
Do not enter. This is system generated at year-end. |
Recipient Code |
R |
Government assigned code for type of recipient. Enter 01. |
Note: An em dash (�") in the table above indicates a field that is automatically populated by the system or that is not needed.
Field Name |
Required (R) or Optional (O) |
Description |
Service Credit Type |
R |
Type of service credit being claimed by the employee. Examples: Concurrent SUNY Service Prior SUNY Service Prior NonSUNY Service
|
Field Name |
Required (R) or Optional (O) |
Description |
Organization |
R |
Specific location and specific department at the location to which the person is assigned (i.e., NOT the Operating Location Org). For example: 010-Small Business Development Center
This field, which defaults to Research Foundation as the organization, must be changed to reflect the accurate organization for the person record for reporting and querying records. It activates the Choose an Option form. |
Field Name |
Required (R) or Optional (O) |
Description |
Operating Location |
R |
Location where the employee will work. |
Assignment Group |
R |
Employee group. Select from the List of Values: Employee Graduate Employee Regular Employee Summer Employee Undergraduate
|
Field Name |
Required (R) or Optional (O) |
Description |
Job |
R |
Enter employee's job title. |
Grade |
R |
Enter employee's pay grade. |
Payroll |
R |
Select from the List of Values. Biweekly for RF payroll and SUNY for SUNY payroll. |
Location |
O |
Based on the Organization field, where the employee works. |
Status |
R |
The relationship with the Research Foundation (RF). Use the List of Values to select Active Assignment. If the person is a full time SUNY employee who has an extra service appointment with the RF, select SUNY Extra Service. |
Assignment Category |
R |
Enter employee�™s status. For example: Exempt �" Regular Hourly Non-exempt �" Regular This field is used to determine the PTO (paid time off) accrual List of Values selection in Element Entries. |
Field Name |
Required (R) or Optional (O) |
Description |
Salary Basis |
R |
Employee's pay basis. Use the List of Values to select one of the following: Hourly 37.5 Hourly 40 Salaried Annual Salaried Period
|
Field Name |
Required (R) or Optional (O) |
Description |
Name |
O |
Select supervisor name form the List of Values. |
Worker Number |
O |
Supervisor's Worker Number is auto generated when Name is selected. |
Assignment Number |
O |
Field not used by the Research Foundation. |
Field Name |
Required (R) or Optional (O) |
Description |
Working Hours |
R |
Scheduled weekly work basis. The work basis is the hours basis for an employee�™s standard work week. Change this field if the employee�™s hours basis is other than 37.50 per week (e.g., change to 40.00). |
Field Name |
Required (R) or Optional (O) |
Description |
Government Reporting Entity |
R |
Reporting employment organization. Do NOT change the default of The Research Foundation of SUNY. |
Timecard Required |
R |
Determination of whether a timecard needs to be submitted for payment to the employee. Enter No if the employee is salaried. Enter Yes if the employee is hourly. |
Field Name |
Required (R) or Optional (O) |
Description |
Internal Address |
O |
Not used by the Research Foundation. |
Primary |
R |
Check box - auto generated. Can be change if person has another assignment. |
Reason |
O |
Not used by the Research Foundation. |
Manager |
O |
Not used by the Research Foundation. |
Field Name |
Required (R) or Optional (O) |
Description |
FTE |
R |
Full-time equivalent; a salaried person�™s expected effort on his or her assignment. For example: Enter .50 for salaried employees working half time for the Research Foundation. Enter 0.00 for hourly employees. For salaried employees, the FTE can be a maximum of 1.00. |
Benefit Hours |
O |
System generated data. Do NOT use this field to enter data. |
Annual Benefit Pay |
O |
System generated data. Do NOT use this field to enter data. |
Field Name |
Required (R) or Optional (O) |
Description |
Change Date |
R |
Effective date of the salary or wage rate. |
New Value |
R |
Enter the employee's salary or wage rate. Do NOT use commas. |
Reason [Salary Administration] |
R |
Reason for salary proposal. Select from the List of Values. For example: New Hire |
Field Name |
Required (R) or Optional (O) |
Description |
Retro Required |
R |
Enter Yes. |
Retro Begin Date |
R |
First day the employee was on the payroll he or she missed. |
Retro End Date |
R |
Date of the last pay period run that the employee missed. |
Field Name |
Required (R) or Optional (O) |
Description |
Filing Status (W4 Information) |
R |
Federal filing status. Verify or modify from the employee's IRS Form W-4. |
Allowances (W4 Information) |
R |
The number of exemption allowances the employee claims. Verify or modify from the employee's IRS Form W-4. |
Additional tax (W4 Information) |
O |
The additional tax to be withheld. Verify or modify from the employee's IRS Form W-4. |
FIT (Tax Exemption) |
O |
Check to claim exemption from federal income tax. |
FUTA (Tax Exemption) |
�" |
This field is NOT used by the Research Foundation. |
MEDICARE (Tax exemption) |
O |
Check this box to claim exemption from medicare tax. This box must be checked if the SS box is checked. |
SS (Tax Exemption) |
O |
Check this box to claim exemption from social security tax. This box must be checked if the MEDICARE box is checked. |
Field Name |
Required (R) or Optional (O) |
Description |
Extra Person Information |
O |
If Permanent Resident is selected in the Nationality field, enter "R" for Resident Alien. If Non Citizen in US on Visa is selected in the Nationality field and person does not meet the Substantial Presence Test (SPT), enter "N" for Nonresident Alien. If person meets Substantial Presence Test enter "R" for Resident Alien. If person is a citizen of India and in a student assignment status, leave field blank (null). |
Field Name |
Required (R) or Optional (O) |
Description |
Filing Status (W4 Information) |
R |
State filing status. Verify or modify from the employee's NYS Form IT-2104. |
Allowances (W4 Information) |
R |
The number of exemption allowances the employee claims. Verify or modify from the employee's NYS Form IT-2104. |
Secondary Allowances |
_ |
This field is NOT used by the Research Foundation. |
Exemption Amount |
_ |
This field is NOT used by the Research Foundation. |
Additional Tax (W4 Information) |
O |
The amount of any additional state tax withholding the employee requests. Verify or modify from the employee's NYS Form IT-2104. |
SIT (Tax Exemption) |
O |
Check this box to claim exemption from state income tax. Verify or modify from the employee's NYS Form IT-2104E. |
SDI (Tax Exemption) |
�" |
This field is NOT used by the Research Foundation. |
SUI (Tax Exemption) |
R |
Do NOT check this box. |
WC (Tax Exemption) |
�" |
This field is NOT used by the Research Foundation. |
Note: An em dash (�") in the table above indicates a field that is automatically populated by the system or that is not needed.
Field Name |
Required (R) or Optional (O) |
Description |
Name |
R |
Method of compensation disbursement chosen by the employee. Select from the List of Values. For example: Check, Direct Deposit, Third Party |
Type |
O |
This field is system generated based on input to the Name field. For example, when Direct Deposit is chosen in the Name field, NACHA will display in the Type field. |
Priority |
R |
The number indicating the priority status of method in the Name field. For example: 1 |
Balance Amount |
O |
The dollar amount of pay for which the method in the Name field is used. The Amount or Percentage field must be used. If the amount entered does not equal the total compensation amount, enter an additional pay method. |
Percentage |
R |
Percentage of pay for which the method in the Name field is used. The Percentage or Amount field must be used. If the percentage entered does not equal 100%, enter an additional pay method. |
Field Name |
Required (R) or Optional (O) |
Description |
Account Name |
R |
Name of the account owner. |
Account Type |
R |
Type of account. Select from the List of Values: Checking Account Savings Account
|
Account Number |
R |
Number of the account. |
Transit Code |
R |
Routing number. |
Bank Name |
R |
Name of the bank. |
Bank Branch |
R |
Location of the bank. |