The data value for Assignment profile attribute "Item/SubstituteCompletion" seems to be showing incorrectly.
For example : When one is creating an Assignment Profile and select an attribute as "Item/Substitute Completion" does not match "<ITEM ID>"
In the database its storing the Attribute value correctly in the table "PA_AP_Assoc_Attr"
However the 'value' column is showing incorrect (as a number) instead of the Item ID in the table PA_AP_Attr_Val.
SuccessFactors Learning Management System (LMS) - All Supported Versions
Reproducing the Issue
1. Create an Assignment profile
2. Go to Manage Rules and select Add rule
3. Select the attribute Item/Substitute Completion 'does not equal'
4. Select 1 or 2 Item ID's
5. Check at Database at table PA_AP_Attr_Val the data stored is some numeric value rather than the CPNT_ID
This is expected system behaviour.
The number you see in the Value column of PA_AP_Attr_Val is actually the CPNT_KEY.
The CPNT_KEY is linked to every item and often referenced in the database instead of CPNT_ID. You can find it referenced in the table PA_CPNT.
Assignment; Profile; PA_AP_Attr_Val; PA_CPNT; Rule; Completion; Item; CPNT_ID; , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem