SPA_TRULE_HOL(SQL Table) |
Index Back |
|---|---|
Time Reporting Rule: HolidayTime Reporting Rule: by Holiday List |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SPA_TIME_RULE_ID |
Character(10) | VARCHAR2(10) NOT NULL | Time Reporting Rule ID |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SPA_RULE_STEP |
Number(4,0) | SMALLINT NOT NULL |
Rule Step
Default Value: 1 |
| 5 | SPA_RULE_SEQ |
Number(3,0) | SMALLINT NOT NULL | Rule Sequence |
| 6 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 7 | HOLIDAY_SCHEDULE |
Character(6) | VARCHAR2(6) NOT NULL |
Holiday Schedule
Prompt Table: HOLIDAY_VW |
| 8 | TRC |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: SPA_TRULE_TRC_V |
| 9 | SPA_TIME_THRESH | Number(17,4) | DECIMAL(16,4) NOT NULL | MinThreshold |
| 10 | SPA_TIME_THRESH_MX | Number(17,4) | DECIMAL(16,4) NOT NULL | MaxThreshold |
| 11 | SPA_AMOUNT_THRESH | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount Threshold |
| 12 | SPA_START_TIME | Time(15) | TIMESTAMP | Start time used in time entry with the 24-hour clock option. |
| 13 | SPA_STOP_TIME | Time(15) | TIMESTAMP | Start time used in time entry with the 24-hour clock option. |
| 14 | SPA_OVERRIDE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Unit of Measure for the Managed Services Rates
Prompt Table: SPA_TRULE_UOM_V |
| 15 | SPA_BLACKOUT_DT | Character(1) | VARCHAR2(1) NOT NULL |
Blackout Date
N=No Y=Yes |
| 16 | SPA_NO_PAYOUT | Character(1) | VARCHAR2(1) NOT NULL |
No Payout
N=No Y=Yes Default Value: N |