SFA_CRC_LOOKUP(SQL Table) |
Index Back |
|---|---|
CRC Lookup TableContains cross reference information. Links CRC tag names to PS_SFA_CRC_* fieldnames. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SFA_CR_SCHEMA_VER |
Character(4) | VARCHAR2(4) NOT NULL |
Schema Version
2.0=Version 2.0 3.0=Version 3.0 4.0=Version 4.0 4.0A=Version 4.0a 4.0B=Version 4.0b 4.0C=Version 4.0c 4.0D=Version 4.0d 4.0E=Version 4.0e 5.0=Version 5.0 5.0A=Version 5.0a 5.0B=Version 5.0b |
| 2 | SFA_CR_FIELD_TAG |
Character(70) | VARCHAR2(70) NOT NULL | Field Tag |
| 3 | SFA_CR_PS_RECORD |
Character(15) | VARCHAR2(15) NOT NULL | PeopleSoft Record Name |
| 4 | SFA_CR_PS_FIELD |
Character(18) | VARCHAR2(18) NOT NULL | PeopleSoft Field Name |
| 5 | SFA_CR_SUB_BLOCK | Character(50) | VARCHAR2(50) NOT NULL | Sub Block |
| 6 | SFA_CR_HAS_ATTRIB | Character(1) | VARCHAR2(1) NOT NULL | Has Attributes |
| 7 | SFA_CR_IS_ATTRIB | Character(1) | VARCHAR2(1) NOT NULL | Is Attribute |
| 8 | SFA_CR_FIELD_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Number |