S_TX_USR_FIN_C (ver 15.11.1)
This table is a child table of the Users table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.11.1 | Number(10,0) | The Primary Key for the record. |
| UsersDCID | 15.11.1 | Number(10,0) | The foreign key that links to the Users table. |
| E1594_Auxiliary_Role_ID | 18.6.0 | Varchar2(3) | The Auxiliary Role ID for non-professional staff. |
| Function_Code | 15.11.1 | Varchar2(2) | The function code for the 060 record for the staff. |
| Fund_Code | 15.11.1 | Varchar2(3) | The fund code for the 060 record for the staff. |
| Number_Days_Employed | 15.11.1 | Number(10,0) | The number of days employed for the 050 record for the staff for that year. |
| Object_Code | 15.11.1 | Varchar2(4) | The object code for the 060 record. |
| Organizaton_Code | 15.11.1 | Varchar2(3) | The organization code for the 060 record. |
Payroll_Activity_Code | 15.11.1 | Varchar2(2) | The payroll activity code for the 060 record for the staff. |
| Payroll_Amount | 15.11.1 | Number(10,0) | The payroll amount for the 060 record for the staff person. |
| Percent_Day_Employed | 15.11.1 | Number(10,0) | The percent of day employed for the 050 record for the staff for that year. |
| Program_Intent_Code | 15.11.1 | Varchar2(2) | The program intent code for the 060 record. |
| Record_Type | 15.11.1 | Varchar2(3) | Indicates if the record is an 050 or 060 record. |
| YearID | 15.11.1 | Number(10,0) | Indicates the year for this 050 or 060 record. |