SFA_SLC_HEI_CDPrompt Table: SFA_SLC_HEI_VW
SFA_SLC_ACAD_YRPrompt Table: SFA_SLC_ACYR_VW
SFA_FILE_NAMEPrompt Table: SFA_SLC_HEBSS_H
SFA_SLC_SSNK=Skip
P=Processed
S=Suspended
U=Unprocessed
Prompt Table: PEOPLE_SRCH
SFA_SLC_HEBSSSR(SQL View) |
Index Back |
|---|---|
SLC HEBSS Search RecordSLC HEBSS Search Record |
| SELECT A.SFA_SLC_HEI_CD ,A.SFA_SLC_ACAD_YR ,A.SFA_FILE_NAME ,B.SFA_SLC_SSN ,B.SFA_SLC_PROC_STAT ,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_HEBSS_H A , PS_SFA_SLC_HEBSS_D 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_FILE_NAME = B.SFA_FILE_NAME |
| # | 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_FILE_NAME |
Character(128) | VARCHAR2(128) NOT NULL |
File Name
Prompt Table: SFA_SLC_HEBSS_H |
| 4 | SFA_SLC_SSN |
Character(13) | VARCHAR2(13) NOT NULL | Student Support Nbr |
| 5 | SFA_SLC_PROC_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Processing Status
K=Skip P=Processed S=Suspended U=Unprocessed |
| 6 | SFA_SLC_LAST_NAME | Character(50) | VARCHAR2(50) NOT NULL | Last Name |
| 7 | SFA_SLC_FIRST_NAME | Character(50) | VARCHAR2(50) NOT NULL | First Name |
| 8 | SFA_SLC_BIRTHDATE | Date(10) | DATE | Date of Birth |
| 9 | SFA_SLC_UCAS_NBR | Character(9) | VARCHAR2(9) NOT NULL | UCAS Number |
| 10 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |