GPUS_GRN_IDEMPLIDGPUS_DOCIDNAMEPrompt Table: GPUS_GRN_DOCTBL
N=Customer Data
S=Sample Data
Y=System Data
GPUS_GRN_DOCIDS(SQL Table) |
Index Back |
|---|---|
Garnishment Document IDsGarnishment Document IDs Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPUS_GRN_ID |
Character(16) | VARCHAR2(16) NOT NULL | GPUS_GARNID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | GPUS_DOCIDNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Document ID Name
Prompt Table: GPUS_GRN_DOCTBL |
| 4 | GPUS_DOCIDVALUE | Character(30) | VARCHAR2(30) NOT NULL | Document ID Value |
| 5 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data |