BUSINESS_UNITRATE_PLANLANGUAGE_CDPC_RATE_PLN_LG(SQL View) |
Index Back |
|---|---|
Lang. view for PC_RATE_PLN_ALLLanguage view for PC_RATE_PLN_ALL |
| SELECT A.BUSINESS_UNIT , A.RATE_PLAN , A.LANGUAGE_CD , A.DESCR FROM PS_PC_RATE_PLAN_LG A , PS_PC_RATE_PLN_ALL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RATE_PLAN = B.RATE_PLAN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | 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. |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |