UPGCA_EVENT_TAO(SQL Table) |
Index Back |
|---|---|
Upgrade: Update Events |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | ACCT_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Revenue Recognition Plan |
| 3 | EVENT_NUM |
Number(3,0) | SMALLINT NOT NULL |
Event Number
Default Value: 1 |
| 4 | AP_EVENT_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Accounting Event Type
01=Date 02=Milestone |
| 5 | CA_PER_COMPLETE | Number(12,8) | DECIMAL(11,8) NOT NULL | Percent Complete |
| 6 | PCT_CHANGE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Incremental % Complete |
| 7 | MILESTONE_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project C=Contract |
| 8 | AP_EVENT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Event Status
CAN=Cancelled DON=Completed HLD=Hold Event NEW=Pending PRG=In Progress RDY=Ready RIN=Reversal Initiated RIP=Reversal In Progress RVS=Reversed |
| 9 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 10 | CA_PERCENTAGE | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Percentage |
| 11 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 12 | FROM_DT | Date(10) | DATE | From Date |
| 13 | TO_DT | Date(10) | DATE | To Date |
| 14 | MS_SEQNUM | Number(3,0) | SMALLINT NOT NULL |
Milestone Number
Prompt Table: CA_MS_NST_SN_VW |
| 15 | DAYS_LAG | Number(3,0) | SMALLINT NOT NULL | A number of days lag before an activity/event occurs. |
| 16 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table: BUS_UNIT_PC_VW |
| 17 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: CA_PROJ_MS_VW |
| 18 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: CA_ACT_MS_VW |
| 19 | ACTIVITY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Activity Status
Prompt Table: PROJ_STATUS_TBL |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: CA_CONTR_HDR.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 21 | TEXT254 | Character(254) | VARCHAR2(254) NOT NULL | Text |
| 22 | CA_EVT_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Event Source
1=Standard 2=Fee |