AGENCY_ID1Prompt Table: TAS_AGENCY
MAIN_ACCOUNTPrompt Table: TAS_MAIN_ACCT
TAS_DEFN_VW(SQL View) |
Index Back |
|---|---|
TAS All View |
| SELECT DISTINCT A.AGENCY_ID1 , B.DESCR , A.MAIN_ACCOUNT , C.DESCR FROM PS_TAS_DEFN_TBL A , PS_TAS_AGENCY B , PS_TAS_MAIN_ACCT C WHERE A.AGENCY_ID1 = B.AGENCY_ID1 AND A.MAIN_ACCOUNT = C.MAIN_ACCOUNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGENCY_ID1 |
Character(3) | VARCHAR2(3) NOT NULL |
TAS agency id
Prompt Table: TAS_AGENCY |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | MAIN_ACCOUNT |
Character(4) | VARCHAR2(4) NOT NULL |
Main Account TAS
Prompt Table: TAS_MAIN_ACCT |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Main Account Description |