FA_RUNCTL_SRCH(SQL View) |
Index Back |
---|---|
Process Names Start w/FAAll the job names (Process names) that start with FA. |
SELECT prcsname , prcstype , descr FROM ps_prcsdefn WHERE prcsname IN ('FANAIN10', 'FAMVNA10', 'FANASR10', 'FAPFIN10', 'FAMVPF10', 'FAPFSR10') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(12) | VARCHAR2(12) NOT NULL | Process Name | |
2 | PRCSTYPE | Character(30) | VARCHAR2(30) NOT NULL | Process Type |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |