RUNCNTL_ASG870

(SQL Table)
Index Back

ACG/SMART ESOA

ACG/SMART ESOA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: FED_AID_YR_TBL

4 TIV_SCHOOL_CODE Character(6) VARCHAR2(6) NOT NULL Pell ID Reporting

Prompt Table: TIV_SCHL_CD_VW

5 SFA_ASG_GRANT_TYPE Character(4) VARCHAR2(4) NOT NULL Grant Type
ACG=Academic Competitiveness
SMRT=National SMART
6 PG_BATCH_ID_00 Character(26) VARCHAR2(26) NOT NULL Pell Batch ID

Prompt Table: SFA_ASG_HDR_VW3