SETIDSPA_TIME_RULE_IDEFFDTDefault Value: %date
SPA_RULE_STEPDefault Value: 1
SPA_RULE_SEQDATE_ENTEREDTRCPrompt Table: SPA_TRULE_TRC_V
Prompt Table: SPA_TRULE_UOM_V
N=No
Y=Yes
N=No
Y=Yes
Default Value: N
SPA_TRULE_DATE(SQL Table) |
Index Back |
|---|---|
Time Reporting Rule:DateTime Reporting Rule: by Date |
| # | 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 | DATE_ENTERED |
Date(10) | DATE NOT NULL | Date |
| 7 | TRC |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code
Prompt Table: SPA_TRULE_TRC_V |
| 8 | SPA_TIME_THRESH | Number(17,4) | DECIMAL(16,4) NOT NULL | MinThreshold |
| 9 | SPA_TIME_THRESH_MX | Number(17,4) | DECIMAL(16,4) NOT NULL | MaxThreshold |
| 10 | SPA_AMOUNT_THRESH | Number(27,3) | DECIMAL(26,3) NOT NULL | Amount Threshold |
| 11 | SPA_START_TIME | Time(15) | TIMESTAMP | Start time used in time entry with the 24-hour clock option. |
| 12 | SPA_STOP_TIME | Time(15) | TIMESTAMP | Start time used in time entry with the 24-hour clock option. |
| 13 | SPA_OVERRIDE_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Unit of Measure for the Managed Services Rates
Prompt Table: SPA_TRULE_UOM_V |
| 14 | SPA_BLACKOUT_DT | Character(1) | VARCHAR2(1) NOT NULL |
Blackout Date
N=No Y=Yes |
| 15 | SPA_NO_PAYOUT | Character(1) | VARCHAR2(1) NOT NULL |
No Payout
N=No Y=Yes Default Value: N |