CA_CONS_RATE_VW(SQL View) |
Index Back |
|---|---|
Contrat RatesTo be used on Console |
| SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , EFFDT , EFF_STATUS , BUSINESS_UNIT_PC , PC_TEMPLATE_ID , RATE_PLAN , RATE_TMPL_OPTION FROM PS_CA_RATE A WHERE EFFDT = ( SELECT MAX(EFFDT) FROM PS_CA_RATE WHERE CONTRACT_NUM = A.CONTRACT_NUM AND CONTRACT_LINE_NUM = A.CONTRACT_LINE_NUM AND EFFDT <= %CurrentDateIn AND EFF_STATUS = 'A') AND EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | CONTRACT_LINE_NUM |
Number(3,0) | SMALLINT NOT NULL | Contract Line Num |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Default Value: CA_DETAIL.BUSINESS_UNIT_PC |
| 6 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table: %EDITTABLE4 |
| 7 | RATE_PLAN | Character(15) | VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
Prompt Table: %EDITTABLE5 |
| 8 | RATE_TMPL_OPTION | Character(4) | VARCHAR2(4) NOT NULL |
Rate Option
CRTP=Contract Rate Plan NSTD=Contract Rate Set TMPL=Rate Set URTP=Rate Plan Default Value: TMPL |