General SQL Statements

To get the list of Marital Status SELECT PSK_STAT_KAHWIN, PSK_KTRGN_ST_KAHWIN FROM SN_KD_ST_KAHWIN

Staff related SQL Statements

To identify the staff’s PTJ SELECT KODPTJ_POHON, PTJ_POHON FROM SN_VW_ATT_STAF WHERE NOGAJI_POHON = ‘XXXXXX’ To identify the staff’s JABATAN SELECT KODJABATAN_POHON, JABATAN_POHON FROM SN_VW_ATT_STAF WHERE NOGAJI_POHON = ‘XXXXXX’