SSR_APT_ACT_SCR (SQL Table)	Index Back
APT Action Security Record APT Action Security Record

SSR_APT_ACT_SCR

(SQL Table)

APT Action Security Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRDEFN2

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

3 SSR_ITEM_TYPE Character(20) VARCHAR2(20) NOT NULL Academic Item Type
Prompt Table: SSR_ITEM_TYPE

4 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
N=No Access
Y=Read/Write Access
Default Value: Y

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRDEFN2
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
3	SSR_ITEM_TYPE	Character(20)	VARCHAR2(20) NOT NULL	Academic Item Type Prompt Table: SSR_ITEM_TYPE
4	ACCESS_CD	Character(1)	VARCHAR2(1) NOT NULL	Access Code N=No Access Y=Read/Write Access Default Value: Y