LM_ICALATCH_HST

(SQL Table)
Index Back

Calendar Attachment Record

Record to contain Calendar Attachment related details - History Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
4 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
5 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
6 LM_ATTACH_ID Number(10,0) DECIMAL(10) NOT NULL Attachment ID - System generated unique ID created for each attachment.
7 LM_ICAL_UID Character(24) VARCHAR2(24) NOT NULL Calendar UID
8 LM_NOTIF_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Notification Batch ID

Default Value: 0

9 LM_NOTIF_TRANS_ID Number(10,0) DECIMAL(10) NOT NULL Notification ID
10 LM_UPD_PUSH_STTS Character(4) VARCHAR2(4) NOT NULL Status
DONE=Done
PEND=Pending

Default Value: PEND

11 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
12 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
13 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
14 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
15 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
16 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File