PC_PRQ_RATE_VW2(SQL View) |
Index Back |
---|---|
Rate Templates of Type 'R'This view is used to select rate templates that have a TEMPLATE_TYPE equal to 'R', therefore exlcuding burden templates and contract-specific templates. This view is created for Project Request. |
SELECT B.BUSINESS_UNIT , B.PC_TEMPLATE_ID , A.EFFDT , B.DESCR FROM PS_PC_RATE A , PS_PC_RATE_HDR B WHERE A.TEMPLATE_TYPE = 'R' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PC_TEMPLATE_ID = B.PC_TEMPLATE_ID AND A.TEMPLATE_TYPE = B.TEMPLATE_TYPE AND A.EFFDT = ( SELECT MAX(RATE.EFFDT) FROM PS_PC_RATE RATE WHERE RATE.BUSINESS_UNIT = A.BUSINESS_UNIT AND RATE.PC_TEMPLATE_ID = A.PC_TEMPLATE_ID AND RATE.TEMPLATE_TYPE = A.TEMPLATE_TYPE AND RATE.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |