LM_ACT_IDLM_LC_IDLM_SES_IDLM_FCLTY_IDLM_FCLTY_LOC_VW(SQL View) |
Index Back |
|---|---|
Facility and corresponding locFacility and corresponding location data for Activities |
| SELECT B.LM_ACT_ID , B.LM_LC_ID ,B.LM_SES_ID , A.LM_FCLTY_ID , A.COUNTRY ,C.DESCR , A.STATE ,D.DESCR , A.CITY ,A.CITY_AC FROM PS_LM_FCLTY_TBL A , PS_LM_SES_VW B , PS_COUNTRY_TBL C , PS_STATE_TBL D WHERE A.LM_FCLTY_ID=B.LM_FCLTY_ID AND A.COUNTRY=C.COUNTRY AND A.STATE=D.STATE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ACT_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Activity ID |
| 2 | LM_LC_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Learning Component ID - Blended Learning |
| 3 | LM_SES_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Session ID |
| 4 | LM_FCLTY_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Facility ID |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | COUNTRY_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Country Description |
| 7 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 8 | STATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 9 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 10 | CITY_AC | Character(30) | VARCHAR2(30) NOT NULL | Alternate Character City |