LM_ACT_ML_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_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
4	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID Prompt Table: LM_ML_LG_VW
5	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID Prompt Table: LM_ML_NAME_VW
6	LM_ML_SEL	Character(1)	VARCHAR2(1) NOT NULL	Selection Criteria G=Learner Group L=Learner Default Value: G
7	LM_HST_CRD_ALLOW	Character(1)	VARCHAR2(1) NOT NULL	Allow historical credit Y/N Table Edit
8	LM_HISTCREDIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Historical Credit Type D=Credit Threshold Date P=Historical Credit Period Default Value: P
9	LM_HIST_CRD_PRD	Number(3,0)	SMALLINT NOT NULL	Historical credit period days
10	LM_HIST_DATE	Date(10)	DATE	Historical Date
11	LM_RNW_REQ	Character(1)	VARCHAR2(1) NOT NULL	Renewal Needed N=No Y=Yes Default Value: N
12	LM_RENEWAL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Renewal Type D=Renewal Threshold Date P=Renewal Period Default Value: P
13	LM_RNW_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Renewal period
14	LM_RENW_DATE	Date(10)	DATE	Renewal date
15	LM_DUE_DT_MTHD	Character(2)	VARCHAR2(2) NOT NULL	Due date method DT=Date LP=Learning Period Default Value: LP
16	LM_MAN_LRN_PD	Number(3,0)	SMALLINT NOT NULL	Mandatory Learning Period
17	LM_DUE_DATE	Date(10)	DATE	Due Date