LM_ACT_IDN=Ineligible for Enrollment
X=Not Applicable
Y=Eligible For Enrollment
Default Value: X
LM_SRCH_ELIG_VW(SQL View) |
Index Back |
|---|---|
SES: Eligible for EnrollmentThe flag is set to 'Y' if the activity is eligible for enrollment.. |
| SELECT A2.LM_ACT_ID , A2.LM_CI_ID , CASE WHEN E2.LM_ACT_ID IS NULL THEN 'N' ELSE 'Y' END FROM PS_LM_ACT A2 LEFT OUTER JOIN PS_LM_ELIG_ENRL_VW E2 ON E2.LM_ACT_ID = A2.LM_ACT_ID |
| # | 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_CI_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Item ID - System Generated ID Number associated with each Catalog Item |
| 3 | LM_ELIG_ENRL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Eligible for Enrollment
N=Ineligible for Enrollment X=Not Applicable Y=Eligible For Enrollment Default Value: X |