SETIDTIME_SETTODAY_DATEDefault Value: %date
SEQ_NUMPOS_PERIOD_VW(SQL View) |
Index Back |
|---|---|
Time Periods for Positions |
| SELECT SETID , TIME_SET , TODAY_DATE , SEQ_NUM , PERIOD_START_DT , PERIOD_END_DT , ' ' FROM PS_POS_PERIOD_TBL |
| # | 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 | TIME_HORIZON | Character(30) | VARCHAR2(30) NOT NULL | Time Horizon |