CONTRACT_NUMCONTRACT_LINE_NUMBUSINESS_UNIT_PCRATE_PLANEFFDTDefault Value: %date
A=Active
I=Inactive
CA_PC_RPLAN_VWC(SQL View) |
Index Back |
|---|---|
Contract Rate PlansThis view defines the Contract Rate Plans. |
| SELECT RP.CONTRACT_NUM , RP.CONTRACT_LINE_NUM , RP.BUSINESS_UNIT , RP.RATE_PLAN , EF.EFFDT , EF.EFF_STATUS , RP.DESCR FROM PS_PC_RATE_PLAN RP , PS_PC_RATE_PLAN_EF EF WHERE RP.RATE_PLAN_TYPE = 'C' AND %Join(COMMON_KEYS, PC_RATE_PLAN RP, PC_RATE_PLAN_EF EF) AND EF.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 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 4 | 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. |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |