Use these instructions to set up a new fellow.
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.
Field Name |
Required (R) or Optional (O) |
Description |
Effective Date |
R |
Date for which the record is effective. Enter the fellow's original hire date. |
Field Name |
Required (R) or Optional (O) |
Description |
Last |
R |
Last name. |
First |
R |
First name. |
Title |
R |
Title. Select from the List of Values. For example: MS. |
Prefix |
O |
The person's prefix name. |
Suffix |
O |
|
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. |
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 in the People. Also complete the Non-Citizen Visa and Residency Info form and the Non-Citizen Reporting Info form in the Special Information Types. |
Field Name |
Required (R) or Optional (O) |
Description |
|
R |
|
|
O |
|
|
O |
|
|
R |
|
Field Name |
Required (R) or Optional (O) |
Description |
R |
E-mail address. |
Field Name |
Required (R) or Optional (O) |
Description |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Field Name |
Required (R) or Optional (O) |
Description |
Address |
R |
Street address. |
City |
R |
City of residence. |
State |
R |
State of residence. |
Zip Code |
R |
Zip code. |
Telephone #1, #2 |
O |
Telephone number. |
Type |
R |
Address type. Select from the List of Values. For example: Campus Local-US 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 Date Region |
R |
Date From is automatically filled in by the system. 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 12, 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. |
DEGREE INFORMATION
- If you need to enter degree information, click the area between the scroll bar and the Degree Information field. (White Box)
- Double-click in the Detail field of the Details region to go to the Degree Information form.
- Complete the following fields:
Field Name |
Required (R) or Optional (O) |
Description |
|
R |
|
|
R |
|
|
R |
|
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 fellow is scheduled to attend new fellow orientation. |
Date Attended |
O |
Date the fellow attended new fellow orientation. |
Policy Received |
O |
Did the fellow 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? |
— |
This field is not applicable to Fellows. |
Spouse Here? |
— |
This field is not applicable to Fellows. |
Number of Dependent Residents |
— |
This field is not applicable to Fellows. |
Passport Number |
R |
Passport number. |
Date First Entered US |
R |
Date first entered U.S. |
Date First Employee in US |
— |
This field is not applicable to Fellows. |
Field Name |
Required (R) or Optional (O) |
Description |
Calendar Year |
R |
Calendar year. |
Income Code |
R |
Numeric representation of income as described in the List of Values. Select 15- Scholarship and Fellowship Awards. |
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 New York state (NYS). NYS follows federal rules. Enter the same information that you entered on 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 |
Indicates whether income is from a foreign source. Select Y or N |
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 one of the following from the List of Values: 00- No Tax for exempt payments 14- 14 Percent for taxable payments |
Exemption Code |
R |
Select one of the following from the List of Values: 2- IRC Exempt for internal revenue code exemption 4- Treaty Exempt for treaty exemption 0- Not Exempt for taxable payments |
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. |
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 of fellowship. Select from the List of Values. |
Assignment Group |
R |
Assignment group. Select from the List of Values: Fellow
|
Note: When changing data fields in Oracle, the system may prompt you to “update” the record and keep a history of changes or to “correct” the previous entry without keeping a history. Always select to Update a record.
Field Name |
Required (R) or Optional (O) |
Description |
Job |
R |
Enter No Job Required. |
Grade |
R |
Enter N/A.0. |
Payroll |
R |
Select Biweekly from the List of Values. |
Location |
R |
Based on the Organization field, where the fellow works. |
Status |
R |
The relationship with the Research Foundation (RF). Use the List of Values to select Active Assignment. |
Assignment Category |
R |
Enter Not an Employee. |
Field Name |
Required (R) or Optional (O) |
Description |
Salary Basis |
R |
Enter Non Employee. |
Field Name |
Required (R) or Optional (O) |
Description |
Name |
O |
Select supervisor name from the List of Values. |
Worker Number |
O |
Supervisor's worker number is system generated when Name is selected. |
Field Name |
Required (R) or Optional (O) |
Description |
Working Hours |
R |
Scheduled weekly work basis. The work basis is the hours basis for a fellow’s standard work week. Change this field if the fellow’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 |
Will have to type in (The Research Foundation of SUNY). |
Field Name |
Required (R) or Optional (O) |
Description |
Primary |
R |
Check box - auto generated. Can be changed if person has another assignment. |
Field Name |
Required (R) or Optional (O) |
Description |
FTE |
R |
Enter 0.00. |
Benefit Hours |
O |
System generated. Do NOT use this field to enter data. |
Annual Benefit Pay |
O |
System generated. Do NOT use this field to enter data. |
Field Name |
Required (R) or Optional (O) |
Description |
Award Amount |
R |
Total award amount granted to the fellow. |
Begin Date |
R |
Date award is to begin. |
End Date |
R |
Date award will end. |
Fellowship Type |
R |
Select the correct type from the List of Values. For Example: Graduate Undergraduate Regular
|
Field Name |
Required (R) or Optional (O) |
Description |
Retro Required |
R |
Select Yes from the List of Values. |
Retro Begin Date |
R |
Begin date of the retroactive period. |
Retro End Date |
R |
End date of the retroactive period. |
Field Name |
Required (R) or Optional (O) |
Description |
Name |
R |
Method of compensation disbursement chosen by fellow. For Example: Direct Deposit |
Type |
O |
The system automatically fills in this field based what you entered in the Name field. For Example: When “Direct Deposit” is chosen in the Name field, NACHA will display in the Type field. |
Priority |
R |
Number indicating the priority status of method. For Example: 1 |
Balance Amount |
O |
Dollar amount of pay for which the method in the Name field is used. The Amount OR the Percentage field must be used. If the amount entered does not equal the total compensation amount, enter an additional pay method. |
Percentage |
C |
Percentage of pay for which the method in the Name field is used. The Percentage OR the 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. For Example: Checking Savings |
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. |