EP_RTG_MDL_SRCH(SQL View) |
Index Back |
---|---|
Rating Models |
SELECT A.RATING_MODEL , B.DESCR FROM PS_EP_RTG_MDL_TBL A , PS_RATING_MDL_TBL B WHERE A.RATING_MODEL = B.RATING_MODEL AND %EffdtCheck(RATING_MDL_TBL B1, B, %CurrentDateIn) AND EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | RATING_MODEL | Character(4) | VARCHAR2(4) NOT NULL |
Rating Model
Prompt Table: EP_RTG_MDL_VW |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |