JPM_APRPROF_VW

(SQL View)
 Index Back

Profile Approval Profile Descr

Profile Approval Transaction Header record.

SELECT HDR.JPM_PROFILE_ID , HDR.JPM_JP_TRAN_NUM , HDR.JPM_JP_SUBMIT_DTTM , HDR.JPM_WF_STATUS , HDR.ORIGINATORID , HDR.JPM_ROLE , HDR.JPM_JP_COMMENTS , HDR.JPM_JP_ORIG_URL , HDR.JPM_JP_PRFL_STATUS , PRF.DESCR FROM PS_JPM_JP_WF_HDR HDR , PS_JPM_PROFILE PRF WHERE PRF.JPM_PROFILE_ID = HDR.JPM_PROFILE_ID

  • Related Language Record: JPM_APRPROF_LVW

    • # 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 JPM_JP_SUBMIT_DTTM DateTime(26) TIMESTAMP Date/Time when profile was submitted for approval.
    4 JPM_WF_STATUS Character(2) VARCHAR2(2) NOT NULL JPM Workflow Status field
    A=Approved
    D=Denied
    N=New
    P=Pending
    S=Saved

    Default Value: P

    5 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    6 JPM_ROLE Character(3) VARCHAR2(3) NOT NULL Role
    ADM=Administrator
    EMP=Employee
    MGR=Manager
    7 JPM_JP_COMMENTS Long Character CLOB Comments
    8 JPM_JP_ORIG_URL Character(254) VARCHAR2(254) NOT NULL Approval's Originating URL
    9 JPM_JP_PRFL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of JPM Profile
    A=Active
    I=Inactive
    10 JPM_PROFILE_DESCR Character(30) VARCHAR2(30) NOT NULL Description