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. The following describes each column on this table.
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 service agreement in the system. If you leave this blank and opt to let the system find the SA during adjustment upload preprocessing, a Determine SA algorithm must be plugged in on the associated adjustment type. This plug-in is meant to derive the SA 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. |