NAME_DISPLAY_TYPEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
1=PSTEXT
2=STRONG
3=PABOLDTEXT
4=PABOLDBLUETEXT
Prompt Table:
SCC_NDT_STYL_VW
Set Control Field: NM_DISP_TYPE_STYLE
SCC_NDT_TBL_VW(SQL View) |
Index Back |
|---|
| SELECT NAME_DISPLAY_TYPE , EFFDT , EFF_STATUS , DESCRSHORT , DESCR , NM_DISP_TYPE_STYLE 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 B.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME_DISPLAY_TYPE |
Character(30) | VARCHAR2(30) NOT NULL | Name Display Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | NM_DISP_TYPE_STYLE | Character(30) | VARCHAR2(30) NOT NULL |
Style
1=PSTEXT 2=STRONG 3=PABOLDTEXT 4=PABOLDBLUETEXT Prompt Table:
SCC_NDT_STYL_VW
|