JPM_JP_TYPEEFFDTDefault Value: %date
A=Active
I=Inactive
P=Pending
Default Value: A
J=Non-Person
P=Person
Prompt Table: JPM_JP_USAGE_VW
JPM_JP_TYPES_I(SQL View) |
Index Back |
|---|---|
Profile Types - Interface ViewInterface view for the Profile Type record. This interface is used to expose the Profile Type information to other applications outside of JPM. Applications inside the HRMS db can access this view directly, while applications that reside outside the HRMS db must use an EIP built upon this view (or rather a derived record that is basically this view). |
| SELECT JPM_JP_TYPE , EFFDT , DESCR , JPM_JP_TYPE_STATUS , JPM_PROFILE_USAGE FROM PS_JPM_JP_TYPES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | JPM_JP_TYPE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Job Profile Type
A=Active I=Inactive P=Pending Default Value: A |
| 5 | JPM_PROFILE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
J=Non-Person P=Person Prompt Table: JPM_JP_USAGE_VW |