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
Prompt Table: CAL_FY_VW |
| 4 | FROM_YEAR | Number(4,0) | SMALLINT NOT NULL |
From Year
Prompt Table: CAL_FY_VW |
| 5 | TO_YEAR | Number(4,0) | SMALLINT NOT NULL |
To Year
Prompt Table: CAL_FY_VW |
| 6 | PERIOD | Number(3,0) | SMALLINT NOT NULL | Period |
| 7 | FROM_PERIOD | Number(3,0) | SMALLINT NOT NULL |
From Period
Prompt Table: CAL_AP_VW |
| 8 | TO_PERIOD | Number(3,0) | SMALLINT NOT NULL |
To Period
Prompt Table: CAL_AP_VW |
| 9 | ASOFDATE | Date(10) | DATE | As of Date |
| 10 | PROCESS_DATE | Date(10) | DATE | Process Date |
| 11 | FROM_DATE | Date(10) | DATE | From Date |
| 12 | TO_DATE | Date(10) | DATE | Latest Date to be sent to PYR |
| 13 | EFFECTIVE_DATE | Date(10) | DATE | Effective Date |
| 14 | PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once |
| 15 | ASOFDATECOND | Character(1) | VARCHAR2(1) NOT NULL |
As Of Date Condition
D=Days After V=Absolute Value |
| 16 | BUDATECOND | Character(1) | VARCHAR2(1) NOT NULL | BU Process Date Condition |
| 17 | FROMDATECOND | Character(1) | VARCHAR2(1) NOT NULL |
From Date Condition
D=Days After V=Absolute Value |
| 18 | TODATECOND | Character(1) | VARCHAR2(1) NOT NULL |
To Date Condition
D=Days After V=Absolute Value |
| 19 | TREEEFFCTDATECOND | Character(1) | VARCHAR2(1) NOT NULL |
Tree Effective Date
D=Days After V=Absolute Value |
| 20 | DAYSAFTER_ASOFDATE | Number(3,0) | SMALLINT NOT NULL |
days after Current Time
Default Value: 0 |
| 21 | DATE_OPTION_RC | Character(1) | VARCHAR2(1) NOT NULL |
Request Date Option
A=As Of Date P=BU Process Date |
| 22 | DAYSAFTER_BUDATE | Number(3,0) | SMALLINT NOT NULL |
days after Current Time
Default Value: 0 |
| 23 | DAYSAFTER_EFFTDATE | Number(3,0) | SMALLINT NOT NULL |
days after Current Time
Default Value: 0 |
| 24 | DAYSAFTER_FROMDATE | Number(3,0) | SMALLINT NOT NULL |
days after Current Time
Default Value: 0 |
| 25 | DAYSAFTER_TODATE | Number(3,0) | SMALLINT NOT NULL |
days after Current Time
Default Value: 0 |