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.