SFA_SLC_SSARSRC

(SQL View)
 Index Back

SSAR Header

SLC Student Support Attendance Request Staging Table

SELECT A.SFA_SLC_HEI_CD ,A.SFA_SLC_ACAD_YR ,A.SFA_SLC_FILE_SEQ ,B.SFA_SLC_SSN ,B.SFA_SLC_PROC_STAT ,A.SFA_FILE_NAME ,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_SSARHDR A , PS_SFA_SLC_SSARDTL 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_FILE_SEQ = B.SFA_SLC_FILE_SEQ

# 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_FILE_SEQ Number(5,0) INTEGER NOT NULL Sequence Number
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_FILE_NAME Character(128) VARCHAR2(128) NOT NULL File Name
7 SFA_SLC_LAST_NAME Character(50) VARCHAR2(50) NOT NULL Last Name
8 SFA_SLC_FIRST_NAME Character(50) VARCHAR2(50) NOT NULL First Name
9 SFA_SLC_BIRTHDATE Date(10) DATE Date of Birth
10 SFA_SLC_UCAS_NBR Character(9) VARCHAR2(9) NOT NULL UCAS Number
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH