EORC_TSKUPDVW

(SQL View)
 Index Back

SELECT B.TASK_ID , B.RUN_CNTL_ID ,A.PNLGRPNAME ,A.RECNAME , A.FIELDNAME ,A.PRCSTYPE ,A.PRCSNAME , A.FIELDUSEDAS ,A.OPTIONALDATE FROM PS_EORC_UPDCOND A , PS_EORC_TASK_L B ,PS_EORC_TSK_UPDCND C WHERE A.PRCSTYPE=B.PROCESSTYPE AND A.PRCSNAME=B.PROCESSNAME AND A.PNLGRPNAME =B.PNLGRPNAME AND B.TASK_ID=C.TASK_ID AND B.OPRID=C.OPRID AND ((A.FIELDUSEDAS='FD' AND C.FROMDATECOND='D' AND C.DAYSAFTER_FROMDATE<>0) OR (A.FIELDUSEDAS='FD' AND C.FROMDATECOND='V' AND (C.FROM_DATE IS NOT NULL)) OR (A.FIELDUSEDAS='TD' AND C.TODATECOND='D' AND C.DAYSAFTER_TODATE<>0) OR (A.FIELDUSEDAS='TD' AND C.TODATECOND='V' AND (C.TO_DATE IS NOT NULL)) OR (A.FIELDUSEDAS='FP' AND C.FROM_PERIOD > 0 ) OR (A.FIELDUSEDAS='TP' AND C.TO_PERIOD > 0 ) OR (A.FIELDUSEDAS='YF' AND C.FROM_YEAR > 0 ) OR (A.FIELDUSEDAS='YT' AND C.TO_YEAR > 0 ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TASK_ID Character(18) VARCHAR2(18) NOT NULL Task Identification
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
6 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type
7 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name
8 FIELDUSEDAS Character(2) VARCHAR2(2) NOT NULL Field Used As
AO=As Of Date
ED=Effective Date
FD=From Date
FP=From Period
FY=From Year
OP=Request Date Option
PF=Process Frequency
TD=To Date
TP=To Period
YF=From Year
YT=To Year
9 OPTIONALDATE Character(18) VARCHAR2(18) NOT NULL Optional Date Field