SSR_AM_REQH_VW2

(SQL View)
 Index Back

IAM Enrollment Request

IAM Enrollment Request

SELECT DISTINCT A.SSR_AM_REQUEST_ID , A.SSR_AM_UPDREQ_STAT , A.SSR_AM_ACT_SOURCE , A.RUN_CNTL_ID , A.SSR_AM_REQ_ACTION , A.PROCESS_INSTANCE , R.RUNDTTM , R.RUNSTATUS FROM PS_SSR_AM_REQUEST A , PSPRCSRQST R WHERE A.PROCESS_INSTANCE = R.PRCSINSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_AM_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL AM Request ID
2 SSR_AM_UPDREQ_STAT Character(1) VARCHAR2(1) NOT NULL AM Update Request Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending

Default Value: P

3 SSR_AM_ACT_SOURCE Character(3) VARCHAR2(3) NOT NULL Request Source
A=Admin
AM=Activity Management Sync
APT=Batch APT
B=Batch
BLK=Block Process
R=Run Control Page
S=Staged Transactions
SE=Batch Student Enroll
SS=Self Service
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 SSR_AM_REQ_ACTION Character(3) VARCHAR2(3) NOT NULL Requested Action
STA=Status Updates
6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
7 RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
8 RUNSTATUS Character(2) VARCHAR2(2) NOT NULL Process Scheduler Process Run Status
1=Cancel
10=Not Successful
11=Posted
12=Unable to post
13=Resend
14=Posting
15=Content Generated
16=Pending
17=Success With Warning
18=Blocked
19=Restart
2=Delete
3=Error
4=Hold
5=Queued
6=Initiated
7=Processing
8=Cancelled
9=Success