SETIDTIME_SETTODAY_DATEDefault Value: %date
SEQ_NUMPOS_PERIOD_TBL(SQL Table) |
Index Back |
|---|---|
Time Periods for Positions |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | TIME_SET |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that represents a time horizon definition dataset. |
| 3 | TODAY_DATE |
Date(10) | DATE |
Represents the creation date for a given time set utilized in position processing.
Default Value: %date |
| 4 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | PERIOD_START_DT | Date(10) | DATE | Represents the date commencement point for a given time set utilized in cash worksheet processing. |
| 6 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 7 | VERSION_NUMBER | Number(5,0) | INTEGER NOT NULL | Represents the Tools version number of a given position tree object. |