TIMEFRAME_PERIODA=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
A=Active
I=Inactive
RSFD_TFP_VW(SQL View) |
Index Back |
|---|---|
All Timeframe PeriodsA view of all Timeframe Periods |
| SELECT A.TIMEFRAME_PERIOD , A.PERIOD_TYPE , A.BEGIN_DT , A.END_DT , A.DESCR , A.STATUS , A.TIMEFRAME_ID , A.PERIOD_ID , A.ROLLUP_SEQNUM FROM PS_RSF_TF_PERIOD A WHERE A.RSF_PERIOD_USE IN ( 'A', 'S', 'P') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL | Time Frame |
| 2 | 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 |
| 3 | BEGIN_DT | Date(10) | DATE NOT NULL | Begin Date |
| 4 | END_DT | Date(10) | DATE NOT NULL | This field stores the end date values. |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 7 | TIMEFRAME_ID | Character(15) | VARCHAR2(15) NOT NULL | Time Frame |
| 8 | PERIOD_ID | Character(15) | VARCHAR2(15) NOT NULL | Period |
| 9 | ROLLUP_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |