SAC_BBIX(SQL Table) |
Index Back |
---|---|
BackBone InterlinX RecordBackBone InterlinX Record |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BBIX_ID | Character(30) | VARCHAR2(30) NOT NULL | Integration ID |
2 | DESCR150_MIXED | Character(150) | VARCHAR2(150) NOT NULL | Description |
3 | BBIX_SEGMENT_SIZE | Number(10,0) | DECIMAL(10) NOT NULL | Segment Size (rows) |
4 | BBIX_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Push vs. Pull
P=Data Pull S=Data Push Default Value: S |
5 | BBIX_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
BBIX Integration Type Transaction or Setup/Control
S=Setup Data T=Transaction Data Default Value: S |
6 | SAC_ALLOWBATCH | Character(1) | VARCHAR2(1) NOT NULL |
Allow Batch Flag
N=PeopleCode Only Y=Standard Mode Default Value: Y |
7 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive Default Value: A |