EMPLIDSSF_DEBT_BNK_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.COMMON_ID , c.last_name_srch , c.first_name_srch FROM PS_SSF_STU_BNK_NLD A , PS_SSF_BANK_ACCT B , PS_PEOPLE_SRCH C WHERE A.COMMON_ID = C.EMPLID AND A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.SSF_BANK_ACCT_ID = B.SSF_BANK_ACCT_ID AND B.ACCT_STATUS = 'A' AND %EffdtCheck(SSF_STU_BNK_NLD A2,A,%CURRENTDATEIN) AND A.EFFSEQ = ( SELECT MAX(A1.EFFSEQ) FROM PS_SSF_STU_BNK_NLD A1 WHERE A.COMMON_ID = A1.COMMON_ID AND A.SA_ID_TYPE = A1.SA_ID_TYPE AND A1.EFFDT = A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | LAST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | Last Name |
| 3 | FIRST_NAME_SRCH | Character(30) | VARCHAR2(30) NOT NULL | First Name |