SETIDPrompt Table: SETID_TBL
TIME_SPAN_TYPEPrompt Table: PROJ_TIME_SPAN
PROCESS_INSTANCEDefault Value: 0
TIME_SPAN_NAMEDefault Value: 1
PROJ_TIME_SPAN(SQL Table) |
Index Back |
|---|---|
Project Time SpansProject Time Spans |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | TIME_SPAN_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Time Span Type
Prompt Table: PROJ_TIME_SPAN |
| 3 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL |
Process Instance
Default Value: 0 |
| 4 | TIME_SPAN_NAME |
Character(15) | VARCHAR2(15) NOT NULL | Time Span Name |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |
| 7 | INTEGER_VALUE | Number(16,2) | DECIMAL(15,2) NOT NULL |
Integer Value
Default Value: 1 |