| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PERNR | Applicant number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | PB4004 | APLNO | Allow NULL? |
| 3 | SUBTY | Subtype | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SUBTY | Allow NULL? |
| 4 | OBJPS | Object Identification | nvarchar | 2 | 0 | CHAR | (N' ') | No | | OBJPS | Allow NULL? |
| 5 | SPRPS | Lock Indicator for HR Master Data Record | char | 1 | 0 | CHAR | (N' ') | No | | SPRPS | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 7 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 8 | SEQNR | Number of Infotype Record with Same Key | nvarchar | 3 | 0 | NUMC | (N'000') | No | | SEQNR | Allow NULL? |
| 9 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 10 | UNAME | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 11 | HISTO | Historical Record Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | HISTO | Allow NULL? |
| 12 | ITXEX | Text Exists for Infotype | char | 1 | 0 | CHAR | (N' ') | Yes | | ITXEX | Allow NULL? |
| 13 | REFEX | Reference Fields Exist (Primary/Secondary Costs) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFEX | Allow NULL? |
| 14 | ORDEX | Confirmation Fields Exist | char | 1 | 0 | CHAR | (N' ') | Yes | | ORDEX | Allow NULL? |
| 15 | ITBLD | Infotype Screen Control | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ITBLD | Allow NULL? |
| 16 | PREAS | Reason for Changing Master Data | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T530E | PREAS | Allow NULL? |
| 17 | FLAG1 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 18 | FLAG2 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 19 | FLAG3 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 20 | FLAG4 | Reserved Field/Unused Field | char | 1 | 0 | CHAR | (N' ') | Yes | | NUSED | Allow NULL? |
| 21 | RESE1 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 22 | RESE2 | Reserved Field/Unused Field of Length 2 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUSED2 | Allow NULL? |
| 23 | GRPVL | Grouping Value for Personnel Assignments | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | PCCE_GPVAL | Allow NULL? |
| 24 | TYPEC | Certificate Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC11 | P10P_TYPEC | Allow NULL? |
| 25 | CTNUM | Certificate Identification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_CTNUM | Allow NULL? |
| 26 | CTBEG | Certificate Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_CTBEG | Allow NULL? |
| 27 | CTEND | Certificate Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_CTEND | Allow NULL? |
| 28 | CSTAT | Certificate and Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_CSTAT | Allow NULL? |
| 29 | RENCD | Renewal Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC21 | P10P_RENCD | Allow NULL? |
| 30 | SBG01 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 31 | SEN01 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 32 | SCD01 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T5UPBSTC16 | P10P_SCODE | Allow NULL? |
| 33 | SCL01 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC03 | P10P_CLASS | Allow NULL? |
| 34 | SDN01 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 35 | SST01 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_SSTAT | Allow NULL? |
| 36 | SHQ01 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 37 | SBG02 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 38 | SEN02 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 39 | SCD02 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T5UPBSTC16 | P10P_SCODE | Allow NULL? |
| 40 | SCL02 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC03 | P10P_CLASS | Allow NULL? |
| 41 | SDN02 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 42 | SST02 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_SSTAT | Allow NULL? |
| 43 | SHQ02 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 44 | SBG03 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 45 | SEN03 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 46 | SCD03 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T5UPBSTC16 | P10P_SCODE | Allow NULL? |
| 47 | SCL03 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC03 | P10P_CLASS | Allow NULL? |
| 48 | SDN03 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 49 | SST03 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_SSTAT | Allow NULL? |
| 50 | SHQ03 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 51 | SBG04 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 52 | SEN04 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 53 | SCD04 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T5UPBSTC16 | P10P_SCODE | Allow NULL? |
| 54 | SCL04 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC03 | P10P_CLASS | Allow NULL? |
| 55 | SDN04 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 56 | SST04 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_SSTAT | Allow NULL? |
| 57 | SHQ04 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 58 | SBG05 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 59 | SEN05 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 60 | SCD05 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T5UPBSTC16 | P10P_SCODE | Allow NULL? |
| 61 | SCL05 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T5UPBSTC03 | P10P_CLASS | Allow NULL? |
| 62 | SDN05 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 63 | SST05 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | T5UPBSTC30 | P10P_SSTAT | Allow NULL? |
| 64 | SHQ05 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 65 | SBG06 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 66 | SEN06 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 67 | SCD06 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 68 | SCL06 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 69 | SDN06 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 70 | SST06 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 71 | SHQ06 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 72 | SBG07 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 73 | SEN07 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 74 | SCD07 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 75 | SCL07 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 76 | SDN07 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 77 | SST07 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 78 | SHQ07 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 79 | SBG08 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 80 | SEN08 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 81 | SCD08 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 82 | SCL08 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 83 | SDN08 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 84 | SST08 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 85 | SHQ08 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 86 | SBG09 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 87 | SEN09 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 88 | SCD09 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 89 | SCL09 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 90 | SDN09 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 91 | SST09 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 92 | SHQ09 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 93 | SBG10 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 94 | SEN10 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 95 | SCD10 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 96 | SCL10 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 97 | SDN10 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 98 | SST10 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 99 | SHQ10 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 100 | SBG11 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 101 | SEN11 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 102 | SCD11 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 103 | SCL11 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 104 | SDN11 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 105 | SST11 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 106 | SHQ11 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 107 | SBG12 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 108 | SEN12 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 109 | SCD12 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 110 | SCL12 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 111 | SDN12 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 112 | SST12 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 113 | SHQ12 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 114 | SBG13 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 115 | SEN13 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 116 | SCD13 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 117 | SCL13 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 118 | SDN13 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 119 | SST13 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 120 | SHQ13 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 121 | SBG14 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 122 | SEN14 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 123 | SCD14 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 124 | SCL14 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 125 | SDN14 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 126 | SST14 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 127 | SHQ14 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 128 | SBG15 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 129 | SEN15 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 130 | SCD15 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 131 | SCL15 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 132 | SDN15 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 133 | SST15 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 134 | SHQ15 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 135 | SBG16 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 136 | SEN16 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 137 | SCD16 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 138 | SCL16 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 139 | SDN16 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 140 | SST16 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 141 | SHQ16 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 142 | SBG17 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 143 | SEN17 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 144 | SCD17 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 145 | SCL17 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 146 | SDN17 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 147 | SST17 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 148 | SHQ17 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 149 | SBG18 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 150 | SEN18 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 151 | SCD18 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 152 | SCL18 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 153 | SDN18 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 154 | SST18 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 155 | SHQ18 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 156 | SBG19 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 157 | SEN19 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 158 | SCD19 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 159 | SCL19 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 160 | SDN19 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 161 | SST19 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 162 | SHQ19 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |
| 163 | SBG20 | Area Effective Begin Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SBEGD | Allow NULL? |
| 164 | SEN20 | Area Effective End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P10P_SENDD | Allow NULL? |
| 165 | SCD20 | Code (Classification, Area and Level) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | P10P_SCODE | Allow NULL? |
| 166 | SCL20 | Classification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P10P_CLASS | Allow NULL? |
| 167 | SDN20 | Area Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P10P_SDNUM | Allow NULL? |
| 168 | SST20 | Area Status | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_SSTAT | Allow NULL? |
| 169 | SHQ20 | Highly Qualified | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_HQUAL | Allow NULL? |