PERIOD_TYPEA=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
BEGIN_DTEND_DTTIMEFRAME_PERIODA=Active
I=Inactive
RSF_TF_PD_VW(SQL View) |
Index Back |
|---|---|
All Timeframe PeriodsAll inclusive view on the pipleline timeframes. |
| SELECT PERIOD_TYPE ,BEGIN_DT , END_DT , TIMEFRAME_PERIOD , DESCR , STATUS FROM PS_RSF_PIPE_TF_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERIOD_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Quota Definition Period Type
A=Annual B=Bi-Weekly D=Daily M=Monthly Q=Quarterly S=Semi-Annual W=Weekly |
| 2 | BEGIN_DT |
Date(10) | DATE NOT NULL | Begin Date |
| 3 | END_DT |
Date(10) | DATE NOT NULL | This field stores the end date values. |
| 4 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL | Time Frame |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |