SSR_APTRQ_ACT_V

(SQL View)

SELECT DISTINCT INSTITUTION , SSR_APT_ACTION FROM PS_SSR_APT_REQUEST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	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