JPM_PROFILE_IDPrompt Table: JPM_PROFILE
A=Active
I=Inactive
Default Value: A
J=Non-Person
P=Person
Prompt Table: JPM_TYP_NADM_VW
Prompt Table: PERSON_NAME
Prompt Table: PERSON_NAME
Default Value: %date
Y/N Table Edit
Default Value: N
HRS_NP_PROF_VW(SQL View) |
Index Back |
|---|---|
Search View - Non-Person PrflsSearch record for JPM Non-Person Profiles. These are defined as Profiles that do not have EMPLID specified/populated in the JPM_PROFILE record. That is, they are profiles that are not aligned to a particular person. Used by TAM find applicant searches. REM LNC - FIX TO USE jpm_jp_types_i AND jpm_profile_i? |
| SELECT PROF.JPM_PROFILE_ID , PROF.DESCR , PROF.JPM_JP_PRFL_STATUS , PROF.JPM_PROFILE_USAGE , PROF.JPM_LGCY_PRFL_ID , PROF.JPM_JP_TYPE , PROF.JPM_OWNER_EMPLID , PROF.EMPLID , PROF.STATUS_DT , PROF.LASTUPDDTTM , PROF.LASTUPDOPRID , PROF.JPM_SUBSCRIBE , PROF.DESCRSHORT FROM PS_JPM_PROFILE PROF , PS_JPM_JP_TYPES JPTYPE , PS_JPM_JP_SEC_VW SEC WHERE PROF.EMPLID = ' ' AND PROF.JPM_PROFILE_USAGE <> 'P' AND JPTYPE.JPM_JP_TYPE = PROF.JPM_JP_TYPE AND JPTYPE.JPM_JP_TYPE_STATUS = 'A' AND JPTYPE.JPM_JP_END_PROFILE = 'Y' AND %EffdtCheck(JPM_JP_TYPES JPTYPE1, JPTYPE, %CurrentDateIn) AND SEC.JPM_JP_TYPE = PROF.JPM_JP_TYPE AND SEC.JPM_ROLE = 'EMP' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_PROFILE_ID |
Character(12) | VARCHAR2(12) NOT NULL |
The id, autoassigned or user assigned of the profile. This id is used to group items and other related material together into one coherent profile.
Prompt Table: JPM_PROFILE |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | JPM_JP_PRFL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of JPM Profile
A=Active I=Inactive Default Value: A |
| 4 | 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 |
| 5 | JPM_LGCY_PRFL_ID | Character(12) | VARCHAR2(12) NOT NULL | Previous Profile ID that has been carried across during upgrade of Profiles to JPM |
| 6 | JPM_JP_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Profile Type name for a JPM Profile Type
Prompt Table: JPM_TYP_NADM_VW |
| 7 | JPM_OWNER_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID (or person id) of the owner of the profile.
Prompt Table: PERSON_NAME |
| 8 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 9 | STATUS_DT | Date(10) | DATE |
Status Date
Default Value: %date |
| 10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 11 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 12 | JPM_SUBSCRIBE | Character(1) | VARCHAR2(1) NOT NULL |
JPM Subscribe field
Y/N Table Edit Default Value: N |
| 13 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |