LM_SCHED_TM

(SQL Table)
Index Back

Scheduled Time Structure

Used as the structure for the Scheduled_Time EIP.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
2 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
3 LM_SES_DT Date(10) DATE Session Date
4 LM_START_TM Time(15) TIMESTAMP Start Time
5 LM_END_TM Time(15) TIMESTAMP End Time
6 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
7 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System
8 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber
9 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted
10 LM_EVENT_TYPE Character(4) VARCHAR2(4) NOT NULL Event Type
TRNG=Training
TRNR=Trainer
11 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
12 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
13 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

14 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
15 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
16 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
17 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
18 CITY Character(30) VARCHAR2(30) NOT NULL City
19 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
20 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
21 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
22 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
23 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
24 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
25 COUNTY Character(30) VARCHAR2(30) NOT NULL County
26 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

27 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
28 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
29 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

30 LM_BAS_LC_TYPE Character(3) VARCHAR2(3) NOT NULL Base Learning Component Type
10=Web-based
20=Sessions
30=Webcast
40=Assignment
50=Test
60=Survey
31 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
32 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid
33 LM_SOURCE_IND Character(4) VARCHAR2(4) NOT NULL Source Indicator
EXT=External
HR89=HRMS 89
HRMS=HRMS
LELM=Enterprise Learning