Adjustment Upload Staging
You must create an adjustment upload staging record for each adjustment you want to upload. The name of this table is CI_ADJ_STG_UP.
| Column Name | Length | Req'd | Data Type | Comments |
|---|---|---|---|---|
| ADJ_STG_UP_ID | 12 | Y | N | This is the unique identifier of the adjustment upload staging record. This key is a sequential number so you can use a database function to assign the value when populating the table. |
| ADJ_STG_CTL_ID | 12 | Y | N | The ID of the adjustment staging control that is linked to this adjustment upload staging record. |
| ADJ_TYPE_CD | 8 | Y | A/N | This must correspond to the prime key of one of your adjustment types. Refer to Setting up Adjustment Types for more information. |
| ADJ_STG_UP_STATUS_FLG | 4 | Y | A/N | This must be set to P for Pending. |
| CREATE_DT | 10 | Y | Date | The date when the adjustment occurred. |
| ADJ_AMT | 13.2 | Y | N | The amount of the adjustment. |
| ADJ_SUSPENSE_FLG | 4 | Y | N | This must be set to NSUS for Not In Suspense. |
| SA_ID | 10 | N | A/N |
This must correspond to a valid contract in the system. If you leave this blank and opt to let the system find the contract during adjustment upload preprocessing, a Determine Contract algorithm must be plugged in on the associated adjustment type. This plug-in is meant to derive the contract ID based on supplied miscellaneous information - e.g. information supplied via adjustment characteristic upload staging. |
| ADJ_ID | 10 | N | A/N | Leave this blank. The adjustment upload process populates this. |
| SUSPENSE_ADJ_ID | 10 | N | A/N | Leave this blank. The adjustment upload process populates this. |
| MESSAGE_CATEGORY | 5 | N | N | Leave this blank. The adjustment upload background processes populate this when an error occurs during upload. |
| MESSAGE_NBR | 5 | N | N | Leave this blank. The adjustment upload background processes populate this when an error occurs during upload. |