ITEM_TYPE_SRCH(SQL View) |
Index Back |
---|---|
Item Type Search Record for SFItem Type Search Record for SF |
SELECT A.SETID ,A.ITEM_TYPE ,A.EFFDT ,A.DESCR ,A.ITEM_TYPE_CD ,A.KEYWORD1 ,A.KEYWORD2 ,A.KEYWORD3 ,A.ITEM_TYPE ,A.ITEM_TYPE FROM PS_ITEM_TYPE_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ITEM_TYPE_TBL B WHERE A.SETID = B.SETID AND A.ITEM_TYPE = B.ITEM_TYPE AND B.EFFDT <= %CurrentDateIn) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID Prompt Table: SP_SETID_NONVW |
2 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL | Item Type |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | ITEM_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Item Type Code
A=Application Fee B=Billing Only C=Charge D=Deposit F=Financial Aid G=GL Interface Only H=Withholding I=Interest L=Pre-Paid Tuition P=Payment R=Refund T=Transfers V=Contributor Relations W=Waiver X=Write-off Z=Pay Plan Credit |
6 | KEYWORD1 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word
Prompt Table: %EDITTABLE |
7 | KEYWORD2 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 2
Prompt Table: %EDITTABLE2 |
8 | KEYWORD3 | Character(10) | VARCHAR2(10) NOT NULL |
Key Word 3
Prompt Table: %EDITTABLE3 |
9 | ITEM_TYPE_FROM | Character(12) | VARCHAR2(12) NOT NULL | Item Type From |
10 | ITEM_TYPE_TO | Character(12) | VARCHAR2(12) NOT NULL | Item Type To |