HRS_APPPROFL_VW (SQL View)	Index Back
Search View - Non-Person Prfls Search 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.

HRS_APPPROFL_VW

(SQL View)

Search View - Non-Person Prfls

Search 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.

SELECT P.JPM_PROFILE_ID , S.JPM_ROLE , P.DESCR , P.JPM_JP_PRFL_STATUS , P.JPM_PROFILE_USAGE , P.JPM_LGCY_PRFL_ID , P.JPM_JP_TYPE , P.JPM_OWNER_EMPLID , P.EMPLID , P.STATUS_DT , P.LASTUPDDTTM , P.LASTUPDOPRID , P.JPM_SUBSCRIBE , P.DESCRSHORT , P.DESCRLONG FROM PS_JPM_PROFILE P , PS_JPM_JP_SEC_VW S WHERE S.JPM_JP_TYPE = P.JPM_JP_TYPE

# 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.

2 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
ADM=Administrator
EMP=Employee
MGR=Manager

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
A=Active
I=Inactive
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

6 JPM_LGCY_PRFL_ID Character(12) VARCHAR2(12) NOT NULL Previous Profile ID that has been carried across during upgrade of Profiles to JPM

7 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
Prompt Table: JPM_TYP_NADM_VW

8 JPM_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID (or person id) of the owner of the profile.
Prompt Table: PERSON_NAME

9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

10 STATUS_DT Date(10) DATE Status Date
Default Value: %date

11 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.

12 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.

13 JPM_SUBSCRIBE Character(1) VARCHAR2(1) NOT NULL JPM Subscribe field
Y/N Table Edit
Default Value: N

14 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

15 DESCRLONG Long Character CLOB Long Description

#	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.
2	JPM_ROLE	Character(3)	VARCHAR2(3) NOT NULL	Role ADM=Administrator EMP=Employee MGR=Manager
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	JPM_JP_PRFL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status of JPM Profile A=Active I=Inactive 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
6	JPM_LGCY_PRFL_ID	Character(12)	VARCHAR2(12) NOT NULL	Previous Profile ID that has been carried across during upgrade of Profiles to JPM
7	JPM_JP_TYPE	Character(12)	VARCHAR2(12) NOT NULL	Profile Type name for a JPM Profile Type Prompt Table: JPM_TYP_NADM_VW
8	JPM_OWNER_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID (or person id) of the owner of the profile. Prompt Table: PERSON_NAME
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
10	STATUS_DT	Date(10)	DATE	Status Date Default Value: %date
11	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.
12	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.
13	JPM_SUBSCRIBE	Character(1)	VARCHAR2(1) NOT NULL	JPM Subscribe field Y/N Table Edit Default Value: N
14	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
15	DESCRLONG	Long Character	CLOB	Long Description