SSR_APT_ACT_VW(SQL View) |
Index Back |
|---|---|
View for Apt action |
| SELECT FIELDVALUE , XLATLONGNAME FROM %Table(PSXLATITEM) A WHERE A.FIELDNAME = 'SSR_APT_ACTION' AND A.FIELDVALUE IN ('AIT','RIT','CSB','ERS','EAS','CRS','ASE') AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM %Table(PSXLATITEM) B WHERE B.FIELDNAME = 'SSR_APT_ACTION' AND B.FIELDVALUE IN ('AIT','RIT','CSB','ERS','EAS','CRS','ASE')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SSR_APT_ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
APT Request Action
ACT=Activate Planning Node AIT=Add Item ASE=APT Status Evaluation CAT=Create Ins & Plan Node Attempt CNA=Create Plan Node(s) CRS=Calculate Results CRT=Create Instance CSB=Create Substitution DEL=Delete Planning Node EAS=Enter APT Status ENR=Enrollment ERS=Enter Results RIT=Remove Item SHC=Shopping Cart |
| 2 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |