SPA_TM_TMPL_TRC(SQL Table) |
Index Back |
|---|---|
TRC's for Services TemplatesMultiple TRC's defined for a Service Template. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TE_TEMPLATE_ID |
Character(8) | VARCHAR2(8) NOT NULL | Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets. |
| 3 | SPA_TEMPLATE_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is always Service Time/Expense
D=Deliverables Template T=Resource Template |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | TRC |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: SPA_OT_TRC_VW |
| 6 | GROUP_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Thresholds
Default Value: 0 |
| 7 | MON_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Mon
Default Value: 0 |
| 8 | TUES_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Tue
Default Value: 0 |
| 9 | WED_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Wed
Default Value: 0 |
| 10 | THURS_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Thurs
Default Value: 0 |
| 11 | FRI_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Fri
Default Value: 0 |
| 12 | SAT_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Sat
Default Value: 0 |
| 13 | SUN_THRESH | Number(6,2) | DECIMAL(5,2) NOT NULL |
Sun
Default Value: 0 |