SFA_SLC_RC_ACR(SQL Table) |
Index Back |
---|---|
SLC ACR/TFPR Run ControlStudent Loans Company (SLC) Run Control for ACR/TFPR processing. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SFA_SLC_HEI_CD | Character(4) | VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table: SFA_SLC_HEI_VW |
4 | SFA_SLC_ACAD_YR | Character(4) | VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table: SFA_SLC_ACYR_VW |
5 | SFA_FILE_PATH_NAME | Character(128) | VARCHAR2(128) NOT NULL | File Path and Name |
6 | SFA_SLC_TFPR_IND | Character(1) | VARCHAR2(1) NOT NULL |
TFPR Indicator
Y/N Table Edit |
7 | SFA_SLC_FILE_TYPE1 | Character(3) | VARCHAR2(3) NOT NULL |
File Type
ACR=Attendance Confirmation Reqst EXT=Extended SISF SCA=Short Course Attendance SIS=Student Information Service Default Value: ACR |
8 | SFA_SLC_LIAB_PRD | Character(1) | VARCHAR2(1) NOT NULL |
Liability Period
1=1 2=2 3=3 |
9 | ATTACHSYSFILENAME | Character(128) | VARCHAR2(128) NOT NULL | Unique Sys Filename |
10 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |