LM_RGSCNCRT_HST

#	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_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
4	LM_SCN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Section ID
5	LM_SCN_CMPL_DT	Date(10)	DATE	Section Completion Date
6	LM_EXPR_DT	Date(10)	DATE	Certification Expiration Date is a fixed, preset date when the certification will expire.
7	LM_GRACE_EXPR_DT	Date(10)	DATE	Grace Period Expiration Date
8	LM_RECERT_DT	Date(10)	DATE	Recertification Date
9	LM_RECERT_WRN_DT	Date(10)	DATE	Recertification Warn Date
10	LM_EXPR_WRN_DT	Date(10)	DATE	Expiration Warning Date
11	LM_SCN_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Section Status CANC=Dropped COMP=Completed ENRL=Registered EXPR=Expired INPO=In-Progress REVK=Revoked WARN=Warning
12	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
13	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
14	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
15	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid