JPM_OPNAPR_XREF

(SQL Table)
Index Back

JPM Profile Approval Xref

Cross Reference table for Profile Approvals

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTAFTHREAD_ID Number(10,0) DECIMAL(10) NOT NULL Thread ID
2 PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
4 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
5 PTAFREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 PTAFTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
A=Approved
C=Complete
D=Denied
E=Pending Denial
H=Hard Deny
I=Initial
N=Not Active
P=Pending
S=Suspended
T=Terminated
X=Suspended/Pending Denial

Default Value: N

8 PTAFPARENT_THREAD Number(10,0) DECIMAL(10) NOT NULL Parent Thread ID
9 PTAFDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
10 COMMENTS Long Character CLOB Comment
11 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.
12 JPM_JP_TRAN_NUM Number(12,0) DECIMAL(12) NOT NULL Transaction Number assigned by JPM when Profile updates are submitted for approval.