PERSON_ID_MANAGERTIMEFRAME_PERIODRSFD_MGR_QRP_NO(SQL View) |
Index Back |
|---|---|
Manager quota Seqnum=1This record is used for Manager quota Seqnum=1 |
| SELECT S.PERSON_ID , %TrimSubstr(TF.TIMEFRAME_ID , 1,15) %Concat '-' %Concat %TrimSubstr(TF.PERIOD_ID , 1,15) , TF.TIMEFRAME_ID , TF.PERIOD_ID , INST.PT_CDB_DEF_CUR_CD , 0 FROM PS_RSF_SUSER S , PS_RSFD_TFP_VW TF , PSCDBINSTALL INST WHERE PERIOD_TYPE IN ('Q', 'A') AND NOT EXISTS ( SELECT 'X' FROM PS_RSFD_MGR_QRP_V0 Q WHERE S.PERSON_ID = Q.PERSON_ID_MANAGER AND TF.TIMEFRAME_ID = Q.TIMEFRAME_ID AND TF.PERIOD_ID = Q.PERIOD_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID_MANAGER |
Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 2 | TIMEFRAME_PERIOD |
Character(32) | VARCHAR2(32) NOT NULL | Time Frame |
| 3 | TIMEFRAME_ID | Character(15) | VARCHAR2(15) NOT NULL | Time Frame |
| 4 | PERIOD_ID | Character(15) | VARCHAR2(15) NOT NULL | Period |
| 5 | FROM_CUR | Character(3) | VARCHAR2(3) NOT NULL | From Currency Code |
| 6 | QUOTA_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Quota Amount |