LM_SES_IN_FC_VW

(SQL View)
Index Back

Session Instructor Facility Vw

Session Instructors joined with Facility and Session information.

SELECT DISTINCT(A.LM_INSTR_ID) , B.LM_ACT_ID , B.LM_SES_ID , D.LM_ACT_STATUS , D.LM_CI_ID , B.LM_SES_DT , B.LM_START_TM , B.LM_END_TM , B.TIMEZONE , B.LM_FCLTY_ID , B.LM_FCLTY , B.LM_FCLTY_SHORT , B.LM_ROOM_ID , %subrec(ADDRESS_SBR, B) , %subrec(LM_ROWAUDIT_SBR, A) FROM PS_LM_SES_INSTR A , PS_LM_SESALL_FC_VW B , PS_LM_ACT D WHERE B.LM_ACT_ID = A.LM_ACT_ID AND B.LM_LC_ID = A.LM_LC_ID AND B.LM_SES_ID = A.LM_SES_ID AND D.LM_ACT_ID = A.LM_ACT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
3 LM_SES_ID Number(10,0) DECIMAL(10) NOT NULL Session ID
4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
1=Active
2=Inactive
3=Closed
4=Pending
5=Concluded
5 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
6 LM_SES_DT Date(10) DATE Session Date
7 LM_START_TM Time(15) TIMESTAMP Start Time
8 LM_END_TM Time(15) TIMESTAMP End Time
9 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

Prompt Table: PSTIMEZONE

10 LM_FCLTY_ID Number(10,0) DECIMAL(10) NOT NULL Facility ID
11 LM_FCLTY Character(50) VARCHAR2(50) NOT NULL Facility Description
12 LM_FCLTY_SHORT Character(10) VARCHAR2(10) NOT NULL Facility Short Description
13 LM_ROOM_ID Number(10,0) DECIMAL(10) NOT NULL Room ID
14 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

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

Prompt Table: STATE_TBL

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

Y/N Table Edit

31 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
32 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
33 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
34 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid