GB_GROUP_IDPrompt Table: GB_GROUP_TBL
EP_REVIEW_TYPEPrompt Table: EP_REVW_TYP_VW
LANGUAGE_CDSP_MER_REVW_LNG(SQL View) |
Index Back |
|---|---|
Merit - Revw Type PromptRelated Language Table of Merit Increase by Group - Review Type Prompt Table. This table is the related language table used as prompt table for the Review Type. |
| SELECT DISTINCT M.GB_GROUP_ID , M.EP_REVIEW_TYPE , RL.LANGUAGE_CD , RL.EP_REVW_DESCR FROM PS_SP_MER_INC_ELIG M , PS_EP_REVW_TYP_TBL R , PS_EP_REVWTYP_LANG RL WHERE R.EP_REVIEW_TYPE = M.EP_REVIEW_TYPE AND R.EFF_STATUS = 'A' AND R.EFFDT = ( SELECT MAX(R1.EFFDT) FROM PS_EP_REVW_TYP_TBL R1 WHERE R1.EP_REVIEW_TYPE = M.EP_REVIEW_TYPE AND R1.EFFDT <= M.SP_FROM_DATE) AND RL.EP_REVIEW_TYPE = R.EP_REVIEW_TYPE AND RL.EFFDT = R.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 2 | EP_REVIEW_TYPE |
Character(8) | VARCHAR2(8) NOT NULL |
Review type
Prompt Table: EP_REVW_TYP_VW |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | EP_REVW_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Review description |