COURSE_LISTEFFDTDefault Value: %date
R_COURSE_SEQUENCEPrompt Table: CRSE_CAT_R3_VW
Prompt Table: RQ_CRS_TOPIC_VW
SSR_CLSTDTL_AIR(SQL View) |
Index Back |
|---|
| SELECT a.COURSE_LIST , a.EFFDT , a.R_COURSE_SEQUENCE , a.CRSE_ID , a.CRS_TOPIC_ID , c.SSR_ITEM_ID FROM PS_CLST_DETL_TBL a , PS_SSR_AIR_H_CRSE c , PS_SSR_AIR_HDR d WHERE a.CRSE_ID <> ' ' AND a.CRSE_ID = c.CRSE_ID AND a.CRS_TOPIC_ID = c.CRS_TOPIC_ID AND c.INSTITUTION =d.INSTITUTION AND c.SSR_ITEM_ID = d.SSR_ITEM_ID AND c.EFFDT = d.EFFDT AND d.EFFDT <= a.EFFDT AND d.END_EFFDT >= a.EFFDT AND d.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COURSE_LIST |
Character(9) | VARCHAR2(9) NOT NULL | Course List |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | R_COURSE_SEQUENCE |
Number(7,0) | INTEGER NOT NULL | Course Sequence |
| 4 | CRSE_ID | Character(6) | VARCHAR2(6) NOT NULL |
Course ID
Prompt Table: CRSE_CAT_R3_VW |
| 5 | CRS_TOPIC_ID | Number(3,0) | SMALLINT NOT NULL |
Course Topic ID
Prompt Table: RQ_CRS_TOPIC_VW |
| 6 | SSR_CHILD_ITEM_ID | Character(11) | VARCHAR2(11) NOT NULL | Child Item ID |