EORC_TSK_UPDCND(SQL Table) |
Index Back |
---|
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(18) | VARCHAR2(18) NOT NULL | Task Identification | |
2 | 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 |