EORC_TSK_UPDCND

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TASK_ID Character(18) VARCHAR2(18) NOT NULL Task Identification
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
4 FROM_YEAR Character(4) VARCHAR2(4) NOT NULL From Year
5 EORC_FROM_YEAR Number(4,0) SMALLINT NOT NULL From Year
6 TO_YEAR Number(4,0) SMALLINT NOT NULL To Year
7 PERIOD Number(3,0) SMALLINT NOT NULL Period
8 FROM_PERIOD Number(3,0) SMALLINT NOT NULL From Period
9 TO_PERIOD Number(3,0) SMALLINT NOT NULL To Period
10 ASOFDATE Date(10) DATE As of Date
11 PROCESS_DATE Date(10) DATE Process Date
12 FROM_DATE Date(10) DATE From Date
13 TO_DATE Date(10) DATE Latest Date to be sent to PYR
14 EFFECTIVE_DATE Date(10) DATE Effective Date
15 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once
16 ASOFDATECOND Character(1) VARCHAR2(1) NOT NULL As Of Date Condition
D=Days After
V=Absolute Value
17 BUDATECOND Character(1) VARCHAR2(1) NOT NULL BU Process Date Condition
18 FROMDATECOND Character(1) VARCHAR2(1) NOT NULL From Date Condition
D=Days After
V=Absolute Value
19 TODATECOND Character(1) VARCHAR2(1) NOT NULL To Date Condition
D=Days After
V=Absolute Value
20 TREEEFFCTDATECOND Character(1) VARCHAR2(1) NOT NULL Tree Effective Date
D=Days After
V=Absolute Value
21 DAYSAFTER_ASOFDATE Number(3,0) SMALLINT NOT NULL days after Current Time

Default Value: 0

22 DATE_OPTION_RC Character(1) VARCHAR2(1) NOT NULL Request Date Option
A=As Of Date
P=BU Process Date
23 DAYSAFTER_BUDATE Number(3,0) SMALLINT NOT NULL days after Current Time

Default Value: 0

24 DAYSAFTER_EFFTDATE Number(3,0) SMALLINT NOT NULL days after Current Time

Default Value: 0

25 DAYSAFTER_FROMDATE Number(3,0) SMALLINT NOT NULL days after Current Time

Default Value: 0

26 DAYSAFTER_TODATE Number(3,0) SMALLINT NOT NULL days after Current Time

Default Value: 0