The Update services can access and update effective-dated child-level records according to the date of the record.

A record is defined as effective-dated if the EFFDT property exists in the record. The EFFDT property must be a key. A record does not have to have the EFFSEQ property for the operation to access an effective-dated record. If the EFFSEQ property does not exist, then the operation uses 0 as the sequence number.

The PeopleSoft Adapter takes {EFFDT, Sequence Number} input values and passes them into PeopleSoft API getEffectiveItem(String date, long seqNum) to access a record.

The sequence number is equal to the EFFSEQ value or to 0. If a record with the specified EFFDT and sequence number already exists in the database, then the record will be updated. If a record with specified EFFDT and sequence number does not exist in the database, then a new record will be inserted into the database.

For example, if there are three records in the database containing the following dates:

The input parameters are {6/25/2005, 0}. The copy of row 1 will be created and the properties will be updated based on input values. The result of Update operation will be: