BUSINESS_UNITCOMMON_IDSA_ID_TYPEO=Organization
P=Person
ITEM_NBRDUE_DTLANGUAGE_CDSSF_ITMDUE_VW_L(SQL View) |
Index Back |
|---|---|
Rel Lang for SSF_ITM_DUE_VWRelated language table for SSF_ITM_DUE_VW |
| SELECT A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.ITEM_NBR ,A.DUE_DT ,C.LANGUAGE_CD ,C.DESCR ,C.DESCRSHORT FROM PS_ITEM_DUE_SF A , PS_ITEM_SF B , PS_ITEM_TYPE_LNG C , PS_BUS_UNIT_TBL_SF S WHERE A.SA_ID_TYPE = 'P' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.COMMON_ID = B.COMMON_ID AND A.SA_ID_TYPE = B.SA_ID_TYPE AND A.ITEM_NBR = B.ITEM_NBR AND A.DUE_AMT-A.APPLIED_AMT > 0 AND B.ITEM_TYPE = C.ITEM_TYPE AND A.BUSINESS_UNIT = S.BUSINESS_UNIT AND C.SETID=( SELECT D.SETID FROM PS_SET_CNTRL_REC D WHERE D.RECNAME='ITEM_TYPE_TBL' AND D.SETCNTRLVALUE=S.INSTITUTION) AND C.EFFDT=( SELECT MAX(EFFDT) FROM PS_ITEM_TYPE_TBL Y WHERE Y.SETID=C.SETID AND Y.ITEM_TYPE=C.ITEM_TYPE AND Y.EFFDT <= %CurrentDateIn AND Y.EFF_STATUS = 'A') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SA_ID_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |
| 4 | ITEM_NBR |
Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
| 5 | DUE_DT |
Date(10) | DATE | Due Date |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |