BPW_FILELIST_VW

(SQL View)
 Index Back

SELECT L.PRCSINSTANCE , %subrec(BPW_INSTKEY_SBR, I) , I.BPW_THRD_RUN_CNTL , I.BPW_THRD_PROC_INST , I.BPW_STEP_ID , I.BPW_STEP_PROC_INST , I.BPW_STRC_RUN_CNTL , I.BPW_STRC_PROC_INST , F.CONTENTID , F.FILENAME , F.CDM_FILE_TYPE , F.FILE_SIZE , F.DTTM_CREATED , L.EXPIRATION_DATE , L.LOGFILEONLY_FLAG , L.PRCSTYPE , L.PRCSNAME , I.RUNSTATUS , L.DISTSTATUS , N.URL FROM PS_BPW_STRCINST_VW I , PS_CDM_FILE_LIST F , PS_CDM_FILE_EXT E , PS_CDM_LIST L , PS_CDM_DIST_NODE N , PSPRCSRQST R WHERE F.CDM_FILE_TYPE = E.CDM_FILE_TYPE AND E.DISPLAY_OPTION = '1' AND F.PRCSINSTANCE = L.PRCSINSTANCE AND F.CONTENTID = L.CONTENTID AND L.DISTSTATUS <> '6' AND L.DISTNODENAME = N.DISTNODENAME AND I.BPW_STRC_PROC_INST > 0 AND ((I.BPW_STRC_PROC_INST = R.MAINJOBINSTANCE AND L.PRCSINSTANCE = R.PRCSINSTANCE) OR (I.BPW_STRC_PROC_INST = L.PRCSINSTANCE AND L.PRCSINSTANCE = R.PRCSINSTANCE AND R.MAINJOBINSTANCE = 0))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BPW_PROC_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance Number
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 BPW_PROC_TYPE Character(4) VARCHAR2(4) NOT NULL Business Process Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
5 BPW_PROC_ID Character(30) VARCHAR2(30) NOT NULL Process Weaver ID

Prompt Table: BPW_PROC_DEFN

6 BPW_PROC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Process Run Control ID
7 BPW_THRD_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Thread Run Control ID
8 BPW_THRD_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Thread Instance Number
9 BPW_STEP_ID Character(30) VARCHAR2(30) NOT NULL Step ID
10 BPW_STEP_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Step Instance Number
11 BPW_STRC_RUN_CNTL Character(30) VARCHAR2(30) NOT NULL Step Thread Run Control ID
12 BPW_STRC_PROC_INST Number(10,0) DECIMAL(10) NOT NULL Step Thread Instance Number
13 CONTENTID Number(15,0) DECIMAL(15) NOT NULL Report ID
14 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
15 CDM_FILE_TYPE Character(10) VARCHAR2(10) NOT NULL File types to be referenced by the Distribution Agent for report distribution.
16 FILE_SIZE Number(10,0) DECIMAL(10) NOT NULL Physical File Size
17 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
18 EXPIRATION_DATE Date(10) DATE Expiration Date
19 LOGFILEONLY_FLAG Character(1) VARCHAR2(1) NOT NULL Log File Only Flag
20 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
21 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
22 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
23 DISTSTATUS Character(2) VARCHAR2(2) NOT NULL Distribution Status
0=None
1=Scheduled
2=Processing
3=Generated
4=Unable to Post
5=Posted to Web
6=Delete
7=Posting
9=Pending for Approval
24 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)