SFA_SLC_ACRSRCH(SQL View) |
Index Back |
|---|---|
SLC ACR Staging Search RecordSLC ACR Staging Table Search Record |
| SELECT A.SFA_SLC_HEI_CD ,A.SFA_SLC_ACAD_YR ,A.SFA_SLC_ISSUE_DT ,A.SFA_SLC_LIAB_PRD ,B.SFA_SLC_SSN ,B.SFA_SLC_REC_SEQ ,B.SFA_SLC_PROC_STAT ,A.SFA_FILE_NAME ,A.SFA_SLC_FILE_TYPE1 ,B.SFA_SLC_LAST_NAME ,B.SFA_SLC_FIRST_NAME ,B.SFA_SLC_BIRTHDATE ,B.SFA_SLC_UCAS_NBR ,B.EMPLID FROM PS_SFA_SLC_ACR_HDR A , PS_SFA_SLC_ACR_DTL B WHERE A.SFA_SLC_HEI_CD = B.SFA_SLC_HEI_CD AND A.SFA_SLC_ACAD_YR = B.SFA_SLC_ACAD_YR AND A.SFA_SLC_ISSUE_DT = B.SFA_SLC_ISSUE_DT AND A.SFA_SLC_LIAB_PRD = B.SFA_SLC_LIAB_PRD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SFA_SLC_HEI_CD |
Character(4) | VARCHAR2(4) NOT NULL |
HEI Code
Prompt Table: SFA_SLC_HEI_VW |
| 2 | SFA_SLC_ACAD_YR |
Character(4) | VARCHAR2(4) NOT NULL |
SLC Acad Year
Prompt Table: SFA_SLC_ACYR_VW |
| 3 | SFA_SLC_ISSUE_DT |
Date(10) | DATE |
Issue Date
Prompt Table: SFA_SLC_ACR_HDR |
| 4 | SFA_SLC_LIAB_PRD |
Character(1) | VARCHAR2(1) NOT NULL |
Liability Period
1=1 2=2 3=3 |
| 5 | SFA_SLC_SSN |
Character(13) | VARCHAR2(13) NOT NULL | Student Support Nbr |
| 6 | SFA_SLC_REC_SEQ |
Number(6,0) | INTEGER NOT NULL | Record Sequence |
| 7 | SFA_SLC_PROC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Status
K=Skip P=Processed S=Suspended U=Unprocessed |
| 8 | SFA_FILE_NAME | Character(128) | VARCHAR2(128) NOT NULL | File Name |
| 9 | 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 |
| 10 | SFA_SLC_LAST_NAME | Character(50) | VARCHAR2(50) NOT NULL | Last Name |
| 11 | SFA_SLC_FIRST_NAME | Character(50) | VARCHAR2(50) NOT NULL | First Name |
| 12 | SFA_SLC_BIRTHDATE | Date(10) | DATE | Date of Birth |
| 13 | SFA_SLC_UCAS_NBR | Character(9) | VARCHAR2(9) NOT NULL | UCAS Number |
| 14 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |