SF_PAYMENT_SRCH

(SQL View)
 Index Back

SF Payment Search Record


SELECT B.OPRCLASS ,A.INSTITUTION_SET ,A.SF_PMT_REF_NBR ,A.SEQNUM ,A.COMMON_ID ,C.COUNTRY ,C.NATIONAL_ID_TYPE ,C.NID_DESCRSHORT ,C.NATIONAL_ID ,C.NATIONAL_ID_MSK ,B.BIRTHDATE ,B.BIRTHDATE_MSK ,E.SEX ,D.NAME ,B.CAMPUS_ID ,D.LAST_NAME_SRCH ,D.FIRST_NAME_SRCH FROM PS_SF_PAYMENT A ,PS_PERSON_MSK_VW B ,PS_PERS_NID_MSK_VW C ,PS_HCR_PERSON_NM_I D ,PS_HCR_PER_PDE_I E WHERE B.OPRCLASS = C.OPRCLASS AND A.COMMON_ID = B.EMPLID AND A.COMMON_ID = C.EMPLID AND A.COMMON_ID = D.EMPLID AND A.COMMON_ID = E.EMPLID AND A.SA_ID_TYPE = 'P' AND E.EFFDT = ( SELECT MAX(E1.EFFDT) FROM PS_HCR_PER_PDE_I E1 WHERE E1.EMPLID=E.EMPLID AND E1.EFFDT<=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 INSTITUTION_SET Character(5) VARCHAR2(5) NOT NULL Institution Set

Default Value: OPR_DEF_TBL_CS.INSTITUTION_SET

Prompt Table: SP_ISET_NONVW

3 SF_PMT_REF_NBR Character(12) VARCHAR2(12) NOT NULL Reference Nbr

Default Value: 0

4 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

6 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
7 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type

Prompt Table: NID_TYPE_TBL

8 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
9 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
10 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
11 BIRTHDATE Date(10) DATE Date of Birth
12 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
13 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
14 NAME Character(50) VARCHAR2(50) NOT NULL Name
15 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
16 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
17 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name