SSF_GRPLRV_TRGT(SQL Table) |
Index Back |
---|---|
Group Line Reversal TargetTarget record for the Group Line Population Selection Reversal. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | GROUP_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Group Line Number |
3 | ITEM_NBR | Character(15) | VARCHAR2(15) NOT NULL | Item Nbr |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
6 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
7 | PAYMENT_ID_NBR | Number(12,0) | DECIMAL(12) NOT NULL | Payment ID Nbr |
8 | LINE_REASON_CD | Character(4) | VARCHAR2(4) NOT NULL |
Line Reason Code
Prompt Table: LINE_REASON_TBL |