EORC_TSKUPDVW

(SQL View)

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
AT=Accounting Date
BT=Bill Thru Date
CF=Cycle From Date
CT=Cycle Through Date
ED=Effective Date
ET=Exception Accounting Date
EV=Event Date
FD=From Date
FP=From Period
FY=Fiscal Year
ID=Invoice Date
IF=From Invoice Date
IT=To Invoice Date
OA=Override Accounting Date
OP=Request Date Option
PF=Process Frequency
PR=Period
RD=Request Date
ST=Bills Added On Or After
TD=To Date
TP=To Period
TT=Transaction Date
YF=From Year
YT=To Year

9 OPTIONALDATE Character(18) VARCHAR2(18) NOT NULL Optional Date Field

#	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 AT=Accounting Date BT=Bill Thru Date CF=Cycle From Date CT=Cycle Through Date ED=Effective Date ET=Exception Accounting Date EV=Event Date FD=From Date FP=From Period FY=Fiscal Year ID=Invoice Date IF=From Invoice Date IT=To Invoice Date OA=Override Accounting Date OP=Request Date Option PF=Process Frequency PR=Period RD=Request Date ST=Bills Added On Or After TD=To Date TP=To Period TT=Transaction Date YF=From Year YT=To Year
9	OPTIONALDATE	Character(18)	VARCHAR2(18) NOT NULL	Optional Date Field