PROCESS_INSTANCECOMMON_IDO=Organization
P=Person
SCC_CG_TRGT(SQL Table) |
Index Back |
|---|---|
CommGen PopSelect Target TblThe CommGen PopSelect target tables holds the resulting data set from PopSelect. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | COMMON_ID |
Character(11) | VARCHAR2(11) NOT NULL | Common ID to store Personal ID / Ext Org ID value |
| 3 | SA_ID_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
ID Type
O=Organization P=Person |