JPM_APP_HIST_VW

(SQL View)
 Index Back

Profiles Approval history

JPM Profile Approvals history view

SELECT DISTINCT P.JPM_PROFILE_ID , H.JPM_JP_TRAN_NUM , H.ORIGINATORID , H.JPM_JP_SUBMIT_DTTM , H.JPM_WF_STATUS , P.DESCR , P.JPM_JP_TYPE , P.EMPLID , P.JPM_PROFILE_USAGE , P.JPM_JP_PRFL_STATUS FROM PS_JPM_JP_WF_HDR H , PS_JPM_PROFILE P , PS_JPM_OPNAPR_XREF X WHERE H.JPM_PROFILE_ID = P.JPM_PROFILE_ID AND X.JPM_PROFILE_ID = H.JPM_PROFILE_ID AND X.JPM_JP_TRAN_NUM = H.JPM_JP_TRAN_NUM

# 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_JP_TRAN_NUM Number(12,0) DECIMAL(12) NOT NULL Transaction Number assigned by JPM when Profile updates are submitted for approval.
3 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
4 JPM_JP_SUBMIT_DTTM DateTime(26) TIMESTAMP Date/Time when profile was submitted for approval.
5 JPM_WF_STATUS Character(2) VARCHAR2(2) NOT NULL JPM Workflow Status field
A=Approved
D=Denied
N=New
P=Pending
S=Saved
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 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.
A=Administrator Only
J=End / Final / Job
P=Person
T=Template
10 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
A=Active
I=Inactive