FIELDVALUEEFFDTA=Active
I=Inactive
XL_ENRL_ACTN_VW(SQL View) |
Index Back |
|---|---|
Xlat View Grading Basis EnrlView of the table XLATTABLE for Enrollment Action. This Dynamic View will allow Enrollment Action Reason to be linked to both Enrollment Action and Enrollment Request Action. |
| SELECT FIELDVALUE , EFFDT , EFF_STATUS , XLATLONGNAME , XLATSHORTNAME FROM PSXLATITEM WHERE (FIELDNAME = 'ENRL_ACTION' OR FIELDNAME = 'ENRL_REQ_ACTION' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDVALUE |
Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |