SSR_GRAD_NAMEUSAGEPrompt Table:
SCC_NMD_TYP_TBL
Set Control Field: NAME_DISPLAY_TYPE
SCC_GRNM_USG_VW(SQL View) |
Index Back |
|---|
| SELECT A.NAME_DISPLAY_TYPE , A.DESCR FROM %Table(SCC_NMD_TYP_TBL) A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(SCC_NMD_TYP_TBL) B WHERE A.NAME_DISPLAY_TYPE = B.NAME_DISPLAY_TYPE AND A.EFFDT = B.EFFDT AND B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_GRAD_NAMEUSAGE |
Character(30) | VARCHAR2(30) NOT NULL |
Name Display Type
Prompt Table:
SCC_NMD_TYP_TBL
|
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |