COUNTRYGP_ELN_APP_CNTRYGP_ELN_APP_CNTR(SQL View) |
Index Back |
|---|---|
Application Country PromptApplication Country Prompt |
| SELECT A.COUNTRY , B.COUNTRY FROM PS_GP_COUNTRY A , PS_GP_COUNTRY B WHERE A.COUNTRY = B.COUNTRY OR B.COUNTRY = 'ALL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | GP_ELN_APP_CNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Application Country |