NAME_USAGEDefault Value: NAME_USAGE_TBL.DESCR
Y/N Table Edit
Default Value: N
J_NAME_USAGE_VW(SQL View) |
Index Back |
|---|---|
Name Usage TableNAME_USAGE_TBL stores the various institution's views of an individual's set of names. |
| SELECT NAME_USAGE , DESCR , DESCRSHORT , JOINT_USAGE FROM PS_NAME_USAGE_TBL WHERE JOINT_USAGE='Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME_USAGE |
Character(10) | VARCHAR2(10) NOT NULL | Name Usage |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: NAME_USAGE_TBL.DESCR |
| 4 | JOINT_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Joint Usage
Y/N Table Edit Default Value: N |