SSR_HM_SCTZ_LTQ

(SQL View)
Index Back

Student Citizenship transactio

Last successful Student Citizenship transaction to HEIMS

SELECT STU_TXN.EMPLID , STU_TXN.SSR_CITI_RES_CODE , STU_TXN.EFFDT_FROM , STU_TXN.SSR_TRANS_ID , STU_TXN.SSR_SEQ_NBR , STU_TXN.SSR_SEQ_NBR2 , STU_TXN.SSR_MAP_ID , STU_TXN.SCC_ROW_ADD_DTTM , STU_TXN.SCC_ROW_UPD_DTTM FROM %Table(SSR_HM_SCTZ_LTX) LST_TXN , %Table(SSR_HM_CITISHIP) STU_TXN , %Table(SSR_HM_UID_MAP) UMAP WHERE STU_TXN.EMPLID = LST_TXN.EMPLID AND STU_TXN.SSR_TRANS_ID = LST_TXN.SSR_TRANS_ID AND UMAP.EMPLID = STU_TXN.EMPLID AND UMAP.SSR_MAP_ID = STU_TXN.SSR_MAP_ID AND UMAP.EFF_STATUS = 'A' AND UMAP.DELETE_FLAG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SSR_CITI_RES_CODE Character(1) VARCHAR2(1) NOT NULL HEIMS Citizen Resident Code
3 EFFDT_FROM Date(10) DATE Effective Date From
4 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID
5 SSR_SEQ_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
6 SSR_SEQ_NBR2 Number(4,0) SMALLINT NOT NULL Sequence Number 2
7 SSR_MAP_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Map ID
8 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
9 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time