| Data element |
Definition |
COA_BC
Indexed - no
Format - char(1)
May be null? yes |
The Budgetary Control segment of the account combination used for the work request phase. The budgetary control character that represents the level at which funds availability checking occurs.
COA_BC is the third segment of the Accounting Flexfield.
|
COA_CNAC
Indexed - yes
Format - char(3)
May be null? yes |
The Center Net Asset code segment of the account combination used for the work request phase. The first two positions of the COA_CNAC identify the school or center. The last position identifies the Net Asset Class: 0 (Unrestricted); 1 (Temporarily Restricted); 2 (Permanently Restricted). COA_CNAC is the first segment of the Accounting Flexfield. |
COA_CREF
Indexed - yes
Format - char(4)
May be null? yes |
The Center Reference code segment of the account combination used for the work request phase. This is an identifier uniquely defined by each school or center.COA_CREF is used to record information that is important to a school or center but is inappropriate for any other segment of the Accounting Flexfield. The value of the center Reference code is unique within a school or center.COA_CREF is the seventh and last segment of the Accounting Flexfield. |
COA_FUND
Indexed - yes
Format - char(6)
May be null? yes |
The Fund code segment of the account combination used for the work request phase. A fund is the unique identifier for a specific set of financial resources that needs tracking or management.
COA_FUND is the fourth segment of the Accounting Flexfield.
|
COA_OBJECT
Indexed - yes
Format - char(4)
May be null? yes |
The Object code segment of the account combination used for the work request phase. Identifies the asset, liability, revenue, or expense.COA_OBJECT is the fifth segment of the Accounting Flexfield. |
COA_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The Organization code segment of the account combination used for the work request phase. This is a subdivision of the University created for management purposes.An ORGANIZATION belongs to only one responsibility center, and its ORGANIZATION code is unique. That is, no two ORGANIZATIONs will have the same values for COA_ORG.COA_ORG is the second segment of the Accounting Flexfield. |
COA_PROGRAM
Indexed - yes
Format - char(4)
May be null? yes |
The Program code segment of the account combination used for the work request phase. This is an activity or work process commonly defined across the University for tracking a PROGRAM's activity across schools and centers (or across organizations within a school or center).COA_PROGRAM is the sixth segment of the Accounting Flexfield. |
COA_RESPONSIBLE_ORG
Indexed - yes
Format - char(4)
May be null? yes |
The responsible organization for managing the fund code segment of the account combination used for the work request phase. Many organizations may use the same fund, but only one organization -- the COA_RESPONSIBLE_ORG -- is accountable for managing the fund. Those who are authorized to access records for the COA_RESPONSIBLE_ORG for the fund may access all records for the fund, regardless of the value of the COA_ORG in the COA_ACCOUNT for the record. |
DIFFERENTIAL_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Shift differential hours. |
EXTERNAL_CHARGE_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Amount of external charges. |
GL_BILL_DATE
Indexed - no
Format - date
May be null? yes |
The date the record was posted to the General Ledger. |
LAST_EXTRACT_DATE
Indexed - no
Format - date
May be null? yes |
The date the record was extracted to the Data Warehouse, as triggered by the Facility Focus posting date. |
NON_STOCK_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Non-stock cost. |
OFFSET
Indexed - no
Format - char(5)
May be null? yes |
The offset subcode that denotes the Facilities and Real Estate Services ORG 9603 or 9604 of the account distribution. |
OVERTIME_LABOR_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Overtime labor cost. |
OVERTIME_LABOR_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Overtime labor hours. |
PHASE
Indexed - yes
Format - varchar2(15)
May be null? no |
Phases define the tasks and costs involved in performing the requested work. Each phase is associated with one trade or housekeeping shop. Although not mandatory, phase one should occur before phase two, and so on, as a logical way of ordering the steps in a job. The number of phases in a single work request is unlimited.
Facility Focus source: ae_p_phs_e.sort_code
|
PHASE_DESC
Indexed - no
Format - varchar2(70)
May be null? yes |
The explanation of the task required for each particular phase.
Facility Focus source: ae_p_phs_e.phsdsc
|
REGULAR_LABOR_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Regular labor cost. |
REGULAR_LABOR_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Regular labor hours. |
SUBLEDGER_CODE
Indexed - yes
Format - varchar2(1)
May be null? yes |
Work request costs are captured and stored by subledger. These are defined as Labor, Material and Contracted Services |
TOTAL_AMT
Indexed - no
Format - number(18,4)
May be null? yes |
Total cost. |
TOTAL_HRS
Indexed - no
Format - number(18,4)
May be null? yes |
Total hours. |
TRANS_TYPE
Indexed - no
Format - varchar2(10)
May be null? yes |
|
TRANS_TYPE_DESC
Indexed - no
Format - varchar2(40)
May be null? yes |
|
WR_NUMBER
Indexed - yes
Format - varchar2(15)
May be null? no |
The unique number for the work request. It is the number the customer will receive, via email from a FRES customer service rep, letting him/her know that the work has been approved and is going to be placed on a schedule. It remains with the work request through its life.
Facility Focus source: ae_p_pro_e.proposal
|
WR_PHASE_DETAIL_PK
Indexed - yes
Format - number
May be null? no |
The unique key identifying a record in the WORK_REQUEST_PHASE_DETAIL table. |
WR_TITLE
Indexed - yes
Format - varchar2(40)
May be null? yes |
A description of the situation. For example, ‘my bathroom sink is clogged’. If this is a request for chargeable work, the account that is being charged is also in this field.
Facility Focus source: ae_p_pro_e.title
|
