JPM_JP_GTYPE(SQL Table) | 
Index Back | 
|---|---|
Profile Group TypesJPM Profile Group Types. Contains details about the Profile Group Type for JPM. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(12) | VARCHAR2(12) NOT NULL | Group type to which a JPM profile group belongs | |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 3 | JPM_JP_SRCH_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
Include in Search
 Y/N Table Edit Default Value: Y  | 
| 4 | JPM_JP_TYPE_USAGE | Character(1) | VARCHAR2(1) NOT NULL | 
Profile Type Usage.
This field is used in conjunction with the JPM_PROFILE_USAGE field on table JPM_JP_TYPES to provide alternate Transalate value descriptions.  A view of the translates for this field is used as the prompt table for JPM_PROFILE_USAGE instead of the normal translates.
 J=Non-person Profile P=Person Profile  |