TIMEFRAME_PERIODA=Annual
B=Bi-Weekly
D=Daily
M=Monthly
Q=Quarterly
S=Semi-Annual
W=Weekly
A=Active
I=Inactive
RSFD_TFP_QTR_VW(SQL View) |
Index Back |
|---|---|
Quarterly Timeframe PeriodsA view of all Quarterly Timeframe Periods |
| SELECT MAX(A.TIMEFRAME_PERIOD) , MAX(A.PERIOD_TYPE) , A.BEGIN_DT , A.END_DT , MAX(A.ROLLUP_SEQNUM) , A.STATUS , B.XLATSHORTNAME , 'Y' FROM PS_RSF_TF_PERIOD A , PSXLATITEM B WHERE A.STATUS = B.FIELDVALUE AND B.FIELDNAME = 'STATUS' AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn) AND A.STATUS = 'A' AND A.PERIOD_TYPE = 'Q' GROUP BY A.BEGIN_DT, A.END_DT, A.STATUS, B.XLATSHORTNAME |
| # | 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 | ROLLUP_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 7 | STATUS_CAT_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Used for contact center dashboard to display status category short description. |
| 8 | INCL_IN_PLAN | Character(1) | VARCHAR2(1) NOT NULL | Include in Planning |