Table Description
Payslip Instruction: A rolled-up view of the instruction line items that were used when generating payments.

It is used to generate a pay-slip to send to the participant.

Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Financial::Entity Objects::PayslipInstruction::PayslipInstruction
Controlling File: core\model\Packages\Financial Manager Packages\PayslipInstruction_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
pslipInstructionIDkeynoUnique reference number assigned by the system to a Payslip InstructionPAYSLIP_INSTRUCTION_ID SVR_INT64
caseNomineeIDdetailsyesWhen the PaySlip is in respect of a Case Nominee, this identifies the Case Nominee to whom the pay slip is to be issued.CASE_NOMINEE_ID SVR_INT64
concernRoleIDdetailsyesWhen the PaySlip is in respect of a Claimant (Recipient), this identifies the Recipient to whom the pay slip is to be issued.CONCERN_ROLE_ID SVR_INT64
statusCodedetails Code value to denote the Status of the Payslip Instruction. Populated from PayslipInstructionStatus code table.PAYSLIP_INSTRUCTION_STATUS_CODEPayslipInstructionStatusSVR_STRING<10>
creationDatedetails Date Payslip Instruction was created on the system.CURAM_DATE SVR_DATE
Foreign Keys (5)
ChildParent
PayslipInstruction.caseNomineeIDCaseNominee.caseNomineeID
PayslipInstruction.concernRoleIDConcernRole.concernRoleID
PaymentInstrument.pslipInstructionIDPayslipInstruction.pslipInstructionID
PayslipComponent.pslipInstructionIDPayslipInstruction.pslipInstructionID
Payslip.paySlipInstructionIDPayslipInstruction.pslipInstructionID
Indices (2)
Index NameAttributes
PayslipInstrIdxconcernRoleID
IND__808452605caseNomineeID
Operations (3)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifyStatusCodensmodifyOPTIMISTIC_LOCKING: yes
Operation to modify the status code of PayslipInstrument after the payslip has been generated 
Related Pages (2)