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. |