diff options
Diffstat (limited to 'public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl')
| -rw-r--r-- | public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl | 249 |
1 files changed, 125 insertions, 124 deletions
diff --git a/public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl b/public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl index f8e181e3..0d453e15 100644 --- a/public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl +++ b/public/wsdl/IF_MDZ_EVCP_EMPLOYEE_MASTER.wsdl @@ -13,149 +13,149 @@ </xsd:complexType> <xsd:complexType name="CMCTB_EMP_MDG"> <xsd:sequence> - <!-- SEQ:1, Table:CMCTB_EMP_MDG, Field:EMPID, M/O:M, Type:VARC, Size:255, Description:사원번호 --> + <!-- SEQ:1, Table:CMCTB_EMP_MDG, Field:EMPID, M/O:M, Type:CHAR, Size:20, Description:사원번호 --> <xsd:element name="EMPID" type="xsd:string" minOccurs="0"/> - <!-- SEQ:2, Table:CMCTB_EMP_MDG, Field:SINGLEID, M/O:, Type:VARC, Size:255, Description:싱글 ID --> + <!-- SEQ:2, Table:CMCTB_EMP_MDG, Field:SINGLEID, M/O:, Type:CHAR, Size:12, Description:싱글 ID --> <xsd:element name="SINGLEID" type="xsd:string" minOccurs="0"/> - <!-- SEQ:3, Table:CMCTB_EMP_MDG, Field:EPID, M/O:, Type:VARC, Size:255, Description:EPID --> + <!-- SEQ:3, Table:CMCTB_EMP_MDG, Field:EPID, M/O:, Type:CHAR, Size:50, Description:EPID --> <xsd:element name="EPID" type="xsd:string" minOccurs="0"/> - <!-- SEQ:4, Table:CMCTB_EMP_MDG, Field:NAME, M/O:, Type:VARC, Size:255, Description:사원이름 --> + <!-- SEQ:4, Table:CMCTB_EMP_MDG, Field:NAME, M/O:, Type:CHAR, Size:70, Description:사원이름 --> <xsd:element name="NAME" type="xsd:string" minOccurs="0"/> - <!-- SEQ:5, Table:CMCTB_EMP_MDG, Field:ENGNAME, M/O:, Type:VARC, Size:255, Description:사원영문이름 --> + <!-- SEQ:5, Table:CMCTB_EMP_MDG, Field:ENGNAME, M/O:, Type:CHAR, Size:70, Description:사원영문이름 --> <xsd:element name="ENGNAME" type="xsd:string" minOccurs="0"/> - <!-- SEQ:6, Table:CMCTB_EMP_MDG, Field:EMPTYPE, M/O:, Type:VARC, Size:255, Description:인력유형 --> + <!-- SEQ:6, Table:CMCTB_EMP_MDG, Field:EMPTYPE, M/O:, Type:CHAR, Size:20, Description:인력유형 --> <xsd:element name="EMPTYPE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:7, Table:CMCTB_EMP_MDG, Field:DEPTCD, M/O:, Type:VARC, Size:255, Description:부서코드 --> + <!-- SEQ:7, Table:CMCTB_EMP_MDG, Field:DEPTCD, M/O:, Type:CHAR, Size:10, Description:부서코드 --> <xsd:element name="DEPTCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:8, Table:CMCTB_EMP_MDG, Field:PDEPTCD, M/O:, Type:VARC, Size:255, Description:상위부서코드 --> + <!-- SEQ:8, Table:CMCTB_EMP_MDG, Field:PDEPTCD, M/O:, Type:CHAR, Size:10, Description:상위부서코드 --> <xsd:element name="PDEPTCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:9, Table:CMCTB_EMP_MDG, Field:COMPCD, M/O:, Type:VARC, Size:255, Description:회사 코드 --> + <!-- SEQ:9, Table:CMCTB_EMP_MDG, Field:COMPCD, M/O:, Type:CHAR, Size:20, Description:회사 코드 --> <xsd:element name="COMPCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:10, Table:CMCTB_EMP_MDG, Field:CORPCD, M/O:, Type:VARC, Size:255, Description:법인 코드 --> + <!-- SEQ:10, Table:CMCTB_EMP_MDG, Field:CORPCD, M/O:, Type:CHAR, Size:4, Description:법인 코드 --> <xsd:element name="CORPCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:11, Table:CMCTB_EMP_MDG, Field:GNCD, M/O:, Type:VARC, Size:255, Description:총괄코드 --> + <!-- SEQ:11, Table:CMCTB_EMP_MDG, Field:GNCD, M/O:, Type:CHAR, Size:20, Description:총괄코드 --> <xsd:element name="GNCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:12, Table:CMCTB_EMP_MDG, Field:BICD, M/O:, Type:VARC, Size:255, Description:사업장코드 --> + <!-- SEQ:12, Table:CMCTB_EMP_MDG, Field:BICD, M/O:, Type:CHAR, Size:20, Description:사업장코드 --> <xsd:element name="BICD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:13, Table:CMCTB_EMP_MDG, Field:KTL_EMP, M/O:, Type:VARC, Size:255, Description:비용센터 --> + <!-- SEQ:13, Table:CMCTB_EMP_MDG, Field:KTL_EMP, M/O:, Type:CHAR, Size:10, Description:비용센터 --> <xsd:element name="KTL_EMP" type="xsd:string" minOccurs="0"/> - <!-- SEQ:14, Table:CMCTB_EMP_MDG, Field:BIZAREA, M/O:, Type:VARC, Size:255, Description:Business Area --> + <!-- SEQ:14, Table:CMCTB_EMP_MDG, Field:BIZAREA, M/O:, Type:CHAR, Size:4, Description:Business Area --> <xsd:element name="BIZAREA" type="xsd:string" minOccurs="0"/> - <!-- SEQ:15, Table:CMCTB_EMP_MDG, Field:WORKPLC, M/O:, Type:VARC, Size:255, Description:근무처 --> + <!-- SEQ:15, Table:CMCTB_EMP_MDG, Field:WORKPLC, M/O:, Type:CHAR, Size:16, Description:근무처 --> <xsd:element name="WORKPLC" type="xsd:string" minOccurs="0"/> - <!-- SEQ:16, Table:CMCTB_EMP_MDG, Field:PAYPLC, M/O:, Type:VARC, Size:255, Description:Payplace for Employee --> + <!-- SEQ:16, Table:CMCTB_EMP_MDG, Field:PAYPLC, M/O:, Type:CHAR, Size:4, Description:Payplace for Employee --> <xsd:element name="PAYPLC" type="xsd:string" minOccurs="0"/> - <!-- SEQ:17, Table:CMCTB_EMP_MDG, Field:COUNTRYCD, M/O:, Type:VARC, Size:255, Description:국가코드 --> + <!-- SEQ:17, Table:CMCTB_EMP_MDG, Field:COUNTRYCD, M/O:, Type:CHAR, Size:3, Description:국가코드 --> <xsd:element name="COUNTRYCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:18, Table:CMCTB_EMP_MDG, Field:JOBCD, M/O:, Type:VARC, Size:255, Description:직무코드 --> + <!-- SEQ:18, Table:CMCTB_EMP_MDG, Field:JOBCD, M/O:, Type:CHAR, Size:20, Description:직무코드 --> <xsd:element name="JOBCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:19, Table:CMCTB_EMP_MDG, Field:JOBDUTYCD, M/O:, Type:VARC, Size:255, Description:직책코드 --> + <!-- SEQ:19, Table:CMCTB_EMP_MDG, Field:JOBDUTYCD, M/O:, Type:CHAR, Size:15, Description:직책코드 --> <xsd:element name="JOBDUTYCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:20, Table:CMCTB_EMP_MDG, Field:JOBGRDCD, M/O:, Type:VARC, Size:255, Description:직급코드 --> + <!-- SEQ:20, Table:CMCTB_EMP_MDG, Field:JOBGRDCD, M/O:, Type:CHAR, Size:12, Description:직급코드 --> <xsd:element name="JOBGRDCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:21, Table:CMCTB_EMP_MDG, Field:GJOBCD, M/O:, Type:VARC, Size:255, Description:Global 직무 --> + <!-- SEQ:21, Table:CMCTB_EMP_MDG, Field:GJOBCD, M/O:, Type:CHAR, Size:20, Description:Global 직무 --> <xsd:element name="GJOBCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:22, Table:CMCTB_EMP_MDG, Field:GJOBDUTYCD, M/O:, Type:VARC, Size:255, Description:Global 직책 --> + <!-- SEQ:22, Table:CMCTB_EMP_MDG, Field:GJOBDUTYCD, M/O:, Type:CHAR, Size:20, Description:Global 직책 --> <xsd:element name="GJOBDUTYCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:23, Table:CMCTB_EMP_MDG, Field:GJOBGRDCD, M/O:, Type:VARC, Size:255, Description:Global 직급 --> + <!-- SEQ:23, Table:CMCTB_EMP_MDG, Field:GJOBGRDCD, M/O:, Type:CHAR, Size:20, Description:Global 직급 --> <xsd:element name="GJOBGRDCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:24, Table:CMCTB_EMP_MDG, Field:LVABSENCE, M/O:, Type:VARC, Size:255, Description:휴직여부 --> + <!-- SEQ:24, Table:CMCTB_EMP_MDG, Field:LVABSENCE, M/O:, Type:CHAR, Size:1, Description:휴직여부 --> <xsd:element name="LVABSENCE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:25, Table:CMCTB_EMP_MDG, Field:RETIRE, M/O:, Type:VARC, Size:255, Description:퇴직여부 --> + <!-- SEQ:25, Table:CMCTB_EMP_MDG, Field:RETIRE, M/O:, Type:CHAR, Size:1, Description:퇴직여부 --> <xsd:element name="RETIRE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:26, Table:CMCTB_EMP_MDG, Field:DISPATCH, M/O:, Type:VARC, Size:255, Description:파견여부 --> + <!-- SEQ:26, Table:CMCTB_EMP_MDG, Field:DISPATCH, M/O:, Type:CHAR, Size:1, Description:파견여부 --> <xsd:element name="DISPATCH" type="xsd:string" minOccurs="0"/> - <!-- SEQ:27, Table:CMCTB_EMP_MDG, Field:DPSTARTDT, M/O:, Type:VARC, Size:255, Description:파견발령일 --> + <!-- SEQ:27, Table:CMCTB_EMP_MDG, Field:DPSTARTDT, M/O:, Type:DATS, Size:8, Description:파견발령일 --> <xsd:element name="DPSTARTDT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:28, Table:CMCTB_EMP_MDG, Field:DEPENDDT, M/O:, Type:VARC, Size:255, Description:파견종료예정일 --> + <!-- SEQ:28, Table:CMCTB_EMP_MDG, Field:DEPENDDT, M/O:, Type:DATS, Size:8, Description:파견종료예정일 --> <xsd:element name="DEPENDDT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:29, Table:CMCTB_EMP_MDG, Field:ORGDEPTCD, M/O:, Type:VARC, Size:255, Description:원소속부서코드 --> + <!-- SEQ:29, Table:CMCTB_EMP_MDG, Field:ORGDEPTCD, M/O:, Type:CHAR, Size:10, Description:원소속부서코드 --> <xsd:element name="ORGDEPTCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:30, Table:CMCTB_EMP_MDG, Field:ORGPDEPCD, M/O:, Type:VARC, Size:255, Description:원소속부서의 상위부서코드 --> + <!-- SEQ:30, Table:CMCTB_EMP_MDG, Field:ORGPDEPCD, M/O:, Type:CHAR, Size:10, Description:원소속부서의 상위부서코드 --> <xsd:element name="ORGPDEPCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:31, Table:CMCTB_EMP_MDG, Field:ORGCOMPCD, M/O:, Type:VARC, Size:255, Description:원소속회사코드 --> + <!-- SEQ:31, Table:CMCTB_EMP_MDG, Field:ORGCOMPCD, M/O:, Type:CHAR, Size:20, Description:원소속회사코드 --> <xsd:element name="ORGCOMPCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:32, Table:CMCTB_EMP_MDG, Field:ORGCORPCD, M/O:, Type:VARC, Size:255, Description:원소속법인코드 --> + <!-- SEQ:32, Table:CMCTB_EMP_MDG, Field:ORGCORPCD, M/O:, Type:CHAR, Size:4, Description:원소속법인코드 --> <xsd:element name="ORGCORPCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:33, Table:CMCTB_EMP_MDG, Field:ORGBICD, M/O:, Type:VARC, Size:255, Description:원소속사업장코드 --> + <!-- SEQ:33, Table:CMCTB_EMP_MDG, Field:ORGBICD, M/O:, Type:CHAR, Size:20, Description:원소속사업장코드 --> <xsd:element name="ORGBICD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:34, Table:CMCTB_EMP_MDG, Field:OKTL_EMPL, M/O:, Type:VARC, Size:255, Description:원소속부서 비용센터 --> + <!-- SEQ:34, Table:CMCTB_EMP_MDG, Field:OKTL_EMPL, M/O:, Type:CHAR, Size:10, Description:원소속부서 비용센터 --> <xsd:element name="OKTL_EMPL" type="xsd:string" minOccurs="0"/> - <!-- SEQ:35, Table:CMCTB_EMP_MDG, Field:VALFROMDT, M/O:, Type:VARC, Size:255, Description:근무시작일 --> + <!-- SEQ:35, Table:CMCTB_EMP_MDG, Field:VALFROMDT, M/O:, Type:DATS, Size:8, Description:근무시작일 --> <xsd:element name="VALFROMDT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:36, Table:CMCTB_EMP_MDG, Field:VALTODT, M/O:, Type:VARC, Size:255, Description:종료예정일(퇴직일자-정규직일경우) --> + <!-- SEQ:36, Table:CMCTB_EMP_MDG, Field:VALTODT, M/O:, Type:DATS, Size:8, Description:종료예정일(퇴직일자-정규직일경우) --> <xsd:element name="VALTODT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:37, Table:CMCTB_EMP_MDG, Field:DHJOBGRDCD, M/O:, Type:VARC, Size:255, Description:부서장 직급코드 --> + <!-- SEQ:37, Table:CMCTB_EMP_MDG, Field:DHJOBGRDCD, M/O:, Type:CHAR, Size:29, Description:부서장 직급코드 --> <xsd:element name="DHJOBGRDCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:38, Table:CMCTB_EMP_MDG, Field:DHNAME, M/O:, Type:VARC, Size:255, Description:부서장 이름 --> + <!-- SEQ:38, Table:CMCTB_EMP_MDG, Field:DHNAME, M/O:, Type:CHAR, Size:70, Description:부서장 이름 --> <xsd:element name="DHNAME" type="xsd:string" minOccurs="0"/> - <!-- SEQ:39, Table:CMCTB_EMP_MDG, Field:DHSINGLID, M/O:, Type:VARC, Size:255, Description:부서장 SingleID --> + <!-- SEQ:39, Table:CMCTB_EMP_MDG, Field:DHSINGLID, M/O:, Type:CHAR, Size:12, Description:부서장 SingleID --> <xsd:element name="DHSINGLID" type="xsd:string" minOccurs="0"/> - <!-- SEQ:40, Table:CMCTB_EMP_MDG, Field:SOCIALID, M/O:, Type:VARC, Size:255, Description: --> + <!-- SEQ:40, Table:CMCTB_EMP_MDG, Field:SOCIALID, M/O:, Type:CHAR, Size:16, Description: --> <xsd:element name="SOCIALID" type="xsd:string" minOccurs="0"/> - <!-- SEQ:41, Table:CMCTB_EMP_MDG, Field:SOCIALID_DECR, M/O:, Type:VARC, Size:255, Description: --> + <!-- SEQ:41, Table:CMCTB_EMP_MDG, Field:SOCIALID_DECR, M/O:, Type:CHAR, Size:16, Description: --> <xsd:element name="SOCIALID_DECR" type="xsd:string" minOccurs="0"/> - <!-- SEQ:42, Table:CMCTB_EMP_MDG, Field:SEX, M/O:, Type:VARC, Size:255, Description:성별 --> + <!-- SEQ:42, Table:CMCTB_EMP_MDG, Field:SEX, M/O:, Type:CHAR, Size:1, Description:성별 --> <xsd:element name="SEX" type="xsd:string" minOccurs="0"/> - <!-- SEQ:43, Table:CMCTB_EMP_MDG, Field:EMAIL, M/O:, Type:VARC, Size:255, Description:이메일주소 --> + <!-- SEQ:43, Table:CMCTB_EMP_MDG, Field:EMAIL, M/O:, Type:CHAR, Size:40, Description:이메일주소 --> <xsd:element name="EMAIL" type="xsd:string" minOccurs="0"/> - <!-- SEQ:44, Table:CMCTB_EMP_MDG, Field:TELNUM, M/O:, Type:VARC, Size:255, Description:전화번호 --> + <!-- SEQ:44, Table:CMCTB_EMP_MDG, Field:TELNUM, M/O:, Type:CHAR, Size:20, Description:전화번호 --> <xsd:element name="TELNUM" type="xsd:string" minOccurs="0"/> - <!-- SEQ:45, Table:CMCTB_EMP_MDG, Field:MBPHONE, M/O:, Type:VARC, Size:255, Description:개인 휴대폰 전화번호 --> + <!-- SEQ:45, Table:CMCTB_EMP_MDG, Field:MBPHONE, M/O:, Type:CHAR, Size:20, Description:개인 휴대폰 전화번호 --> <xsd:element name="MBPHONE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:46, Table:CMCTB_EMP_MDG, Field:EMPADR, M/O:, Type:VARC, Size:255, Description:주소 --> + <!-- SEQ:46, Table:CMCTB_EMP_MDG, Field:EMPADR, M/O:, Type:CHAR, Size:10, Description:주소 --> <xsd:element name="EMPADR" type="xsd:string" minOccurs="0"/> - <!-- SEQ:47, Table:CMCTB_EMP_MDG, Field:PSTLCODE, M/O:, Type:VARC, Size:255, Description:우편번호 --> + <!-- SEQ:47, Table:CMCTB_EMP_MDG, Field:PSTLCODE, M/O:, Type:CHAR, Size:10, Description:우편번호 --> <xsd:element name="PSTLCODE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:48, Table:CMCTB_EMP_MDG, Field:WFREQUIRE, M/O:, Type:VARC, Size:255, Description:전결필요여부 --> + <!-- SEQ:48, Table:CMCTB_EMP_MDG, Field:WFREQUIRE, M/O:, Type:CHAR, Size:1, Description:전결필요여부 --> <xsd:element name="WFREQUIRE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:49, Table:CMCTB_EMP_MDG, Field:HRMANAGE, M/O:, Type:VARC, Size:255, Description:HR시스템에서 관리 여부 --> + <!-- SEQ:49, Table:CMCTB_EMP_MDG, Field:HRMANAGE, M/O:, Type:CHAR, Size:1, Description:HR시스템에서 관리 여부 --> <xsd:element name="HRMANAGE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:50, Table:CMCTB_EMP_MDG, Field:SINGLRQ, M/O:, Type:VARC, Size:255, Description:싱글ID 요청 상태 --> + <!-- SEQ:50, Table:CMCTB_EMP_MDG, Field:SINGLRQ, M/O:, Type:CHAR, Size:1, Description:싱글ID 요청 상태 --> <xsd:element name="SINGLRQ" type="xsd:string" minOccurs="0"/> - <!-- SEQ:51, Table:CMCTB_EMP_MDG, Field:SOJRNEMP, M/O:, Type:VARC, Size:255, Description:주재원 여부 --> + <!-- SEQ:51, Table:CMCTB_EMP_MDG, Field:SOJRNEMP, M/O:, Type:CHAR, Size:1, Description:주재원 여부 --> <xsd:element name="SOJRNEMP" type="xsd:string" minOccurs="0"/> - <!-- SEQ:52, Table:CMCTB_EMP_MDG, Field:ADDRCNTRY, M/O:, Type:VARC, Size:255, Description:우편번호의 국가코드 --> + <!-- SEQ:52, Table:CMCTB_EMP_MDG, Field:ADDRCNTRY, M/O:, Type:CHAR, Size:3, Description:우편번호의 국가코드 --> <xsd:element name="ADDRCNTRY" type="xsd:string" minOccurs="0"/> - <!-- SEQ:53, Table:CMCTB_EMP_MDG, Field:FORIGNFLG, M/O:, Type:VARC, Size:255, Description:[기획]Foreign Flag --> + <!-- SEQ:53, Table:CMCTB_EMP_MDG, Field:FORIGNFLG, M/O:, Type:CHAR, Size:1, Description:[기획]Foreign Flag --> <xsd:element name="FORIGNFLG" type="xsd:string" minOccurs="0"/> - <!-- SEQ:54, Table:CMCTB_EMP_MDG, Field:USEDSYS, M/O:, Type:VARC, Size:255, Description:[기획]Used System --> + <!-- SEQ:54, Table:CMCTB_EMP_MDG, Field:USEDSYS, M/O:, Type:CHAR, Size:20, Description:[기획]Used System --> <xsd:element name="USEDSYS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:55, Table:CMCTB_EMP_MDG, Field:JOBCLASS, M/O:, Type:VARC, Size:255, Description:[에스원]Job Class Code --> + <!-- SEQ:55, Table:CMCTB_EMP_MDG, Field:JOBCLASS, M/O:, Type:CHAR, Size:20, Description:[에스원]Job Class Code --> <xsd:element name="JOBCLASS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:56, Table:CMCTB_EMP_MDG, Field:TMPJDIV, M/O:, Type:VARC, Size:255, Description:[에스원]Non-Regular Code --> + <!-- SEQ:56, Table:CMCTB_EMP_MDG, Field:TMPJDIV, M/O:, Type:CHAR, Size:20, Description:[에스원]Non-Regular Code --> <xsd:element name="TMPJDIV" type="xsd:string" minOccurs="0"/> - <!-- SEQ:57, Table:CMCTB_EMP_MDG, Field:CSFROMDT, M/O:, Type:VARC, Size:255, Description:[에스원]CS Start Date --> + <!-- SEQ:57, Table:CMCTB_EMP_MDG, Field:CSFROMDT, M/O:, Type:DATS, Size:8, Description:[에스원]CS Start Date --> <xsd:element name="CSFROMDT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:58, Table:CMCTB_EMP_MDG, Field:CSTODT, M/O:, Type:VARC, Size:255, Description:[에스원]CS End Date --> + <!-- SEQ:58, Table:CMCTB_EMP_MDG, Field:CSTODT, M/O:, Type:DATS, Size:8, Description:[에스원]CS End Date --> <xsd:element name="CSTODT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:59, Table:CMCTB_EMP_MDG, Field:CTIROLE, M/O:, Type:VARC, Size:255, Description:[에스원]CTI Authority --> + <!-- SEQ:59, Table:CMCTB_EMP_MDG, Field:CTIROLE, M/O:, Type:CHAR, Size:2, Description:[에스원]CTI Authority --> <xsd:element name="CTIROLE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:60, Table:CMCTB_EMP_MDG, Field:IDNO, M/O:, Type:VARC, Size:255, Description:[모직]개인ID --> + <!-- SEQ:60, Table:CMCTB_EMP_MDG, Field:IDNO, M/O:, Type:CHAR, Size:32, Description:[모직]개인ID --> <xsd:element name="IDNO" type="xsd:string" minOccurs="0"/> - <!-- SEQ:61, Table:CMCTB_EMP_MDG, Field:BSCADDR, M/O:, Type:VARC, Size:255, Description:Basic Address --> + <!-- SEQ:61, Table:CMCTB_EMP_MDG, Field:BSCADDR, M/O:, Type:CHAR, Size:35, Description:Basic Address --> <xsd:element name="BSCADDR" type="xsd:string" minOccurs="0"/> - <!-- SEQ:62, Table:CMCTB_EMP_MDG, Field:DTLADDR, M/O:, Type:VARC, Size:255, Description:Detail Address --> + <!-- SEQ:62, Table:CMCTB_EMP_MDG, Field:DTLADDR, M/O:, Type:CHAR, Size:35, Description:Detail Address --> <xsd:element name="DTLADDR" type="xsd:string" minOccurs="0"/> - <!-- SEQ:63, Table:CMCTB_EMP_MDG, Field:DTLADDR2, M/O:, Type:VARC, Size:255, Description:Detail Address2 --> + <!-- SEQ:63, Table:CMCTB_EMP_MDG, Field:DTLADDR2, M/O:, Type:CHAR, Size:35, Description:Detail Address2 --> <xsd:element name="DTLADDR2" type="xsd:string" minOccurs="0"/> - <!-- SEQ:64, Table:CMCTB_EMP_MDG, Field:ZZBUKRS, M/O:, Type:VARC, Size:255, Description:ECC Company 코드 (재무법인코드) --> + <!-- SEQ:64, Table:CMCTB_EMP_MDG, Field:ZZBUKRS, M/O:, Type:CHAR, Size:4, Description:ECC Company 코드 (재무법인코드) --> <xsd:element name="ZZBUKRS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:65, Table:CMCTB_EMP_MDG, Field:ZPRFLG, M/O:, Type:VARC, Size:255, Description:업데이트 여부 Flag --> + <!-- SEQ:65, Table:CMCTB_EMP_MDG, Field:ZPRFLG, M/O:, Type:CHAR, Size:1, Description:업데이트 여부 Flag --> <xsd:element name="ZPRFLG" type="xsd:string" minOccurs="0"/> - <!-- SEQ:66, Table:CMCTB_EMP_MDG, Field:ERNAM, M/O:, Type:VARC, Size:255, Description:생성자 --> + <!-- SEQ:66, Table:CMCTB_EMP_MDG, Field:ERNAM, M/O:, Type:CHAR, Size:12, Description:생성자 --> <xsd:element name="ERNAM" type="xsd:string" minOccurs="0"/> - <!-- SEQ:67, Table:CMCTB_EMP_MDG, Field:ERDAT, M/O:, Type:VARC, Size:255, Description:생성날짜 --> + <!-- SEQ:67, Table:CMCTB_EMP_MDG, Field:ERDAT, M/O:, Type:DATS, Size:8, Description:생성날짜 --> <xsd:element name="ERDAT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:68, Table:CMCTB_EMP_MDG, Field:ERZET, M/O:, Type:VARC, Size:255, Description:생성시간 --> + <!-- SEQ:68, Table:CMCTB_EMP_MDG, Field:ERZET, M/O:, Type:TIMS, Size:6, Description:생성시간 --> <xsd:element name="ERZET" type="xsd:string" minOccurs="0"/> - <!-- SEQ:69, Table:CMCTB_EMP_MDG, Field:AENAM, M/O:, Type:VARC, Size:255, Description:수정자 --> + <!-- SEQ:69, Table:CMCTB_EMP_MDG, Field:AENAM, M/O:, Type:CHAR, Size:12, Description:수정자 --> <xsd:element name="AENAM" type="xsd:string" minOccurs="0"/> - <!-- SEQ:70, Table:CMCTB_EMP_MDG, Field:AEDAT, M/O:, Type:VARC, Size:255, Description:수정날짜 --> + <!-- SEQ:70, Table:CMCTB_EMP_MDG, Field:AEDAT, M/O:, Type:DATS, Size:8, Description:수정날짜 --> <xsd:element name="AEDAT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:71, Table:CMCTB_EMP_MDG, Field:AEZET, M/O:, Type:VARC, Size:255, Description:최근수정시간 --> + <!-- SEQ:71, Table:CMCTB_EMP_MDG, Field:AEZET, M/O:, Type:TIMS, Size:6, Description:최근수정시간 --> <xsd:element name="AEZET" type="xsd:string" minOccurs="0"/> - <!-- SEQ:72, Table:CMCTB_EMP_MDG, Field:DEL, M/O:, Type:VARC, Size:255, Description:삭제Flag --> + <!-- SEQ:72, Table:CMCTB_EMP_MDG, Field:DEL, M/O:, Type:CHAR, Size:1, Description:삭제Flag --> <xsd:element name="DEL" type="xsd:string" minOccurs="0"/> <xsd:element name="DEPTCODE" type="p0:DEPTCODE" minOccurs="0" maxOccurs="unbounded"/> <xsd:element name="DEPTNM" type="p0:DEPTNM" minOccurs="0" maxOccurs="unbounded"/> @@ -185,207 +185,208 @@ </xsd:complexType> <xsd:complexType name="DEPTCODE"> <xsd:sequence> - <!-- SEQ:73, Table:CMCTB_EMP_MDG/DEPTCODE, Field:PCCD, M/O:, Type:VARC, Size:255, Description:Profit Center Code (DEPTCD) --> + <!-- SEQ:73, Table:CMCTB_EMP_MDG/DEPTCODE, Field:PCCD, M/O:, Type:CHAR, Size:10, Description:Profit Center Code (DEPTCD) --> <xsd:element name="PCCD" type="xsd:string" minOccurs="0"/> - <!-- SEQ:74, Table:CMCTB_EMP_MDG/DEPTCODE, Field:WERKS, M/O:, Type:VARC, Size:255, Description:Plant Code (DEPTCD) --> + <!-- SEQ:74, Table:CMCTB_EMP_MDG/DEPTCODE, Field:WERKS, M/O:, Type:CHAR, Size:4, Description:Plant Code (DEPTCD) --> <xsd:element name="WERKS" type="xsd:string" minOccurs="0"/> <xsd:element name="PCCDNM" type="p0:PCCDNM" minOccurs="0" maxOccurs="unbounded"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="PCCDNM"> <xsd:sequence> - <!-- SEQ:78, Table:CMCTB_EMP_MDG/DEPTNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (DEPTCD) --> + <!-- SEQ:78, Table:CMCTB_EMP_MDG/DEPTNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (DEPTCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:76, Table:CMCTB_EMP_MDG/DEPTCODE/PCCDNM, Field:KTEXT, M/O:, Type:VARC, Size:255, Description:General Name --> + <!-- SEQ:76, Table:CMCTB_EMP_MDG/DEPTCODE/PCCDNM, Field:KTEXT, M/O:, Type:CHAR, Size:20, Description:General Name --> <xsd:element name="KTEXT" type="xsd:string" minOccurs="0"/> - <!-- SEQ:77, Table:CMCTB_EMP_MDG/DEPTCODE/PCCDNM, Field:LTEXT, M/O:, Type:VARC, Size:255, Description:Long Text --> + <!-- SEQ:77, Table:CMCTB_EMP_MDG/DEPTCODE/PCCDNM, Field:LTEXT, M/O:, Type:CHAR, Size:40, Description:Long Text --> <xsd:element name="LTEXT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="DEPTNM"> <xsd:sequence> - <!-- SEQ:78, Table:CMCTB_EMP_MDG/DEPTNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (DEPTCD) --> + <!-- SEQ:78, Table:CMCTB_EMP_MDG/DEPTNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (DEPTCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:79, Table:CMCTB_EMP_MDG/DEPTNM, Field:DEPTNM, M/O:, Type:VARC, Size:255, Description:Department Name (DEPTCD) --> + <!-- SEQ:79, Table:CMCTB_EMP_MDG/DEPTNM, Field:DEPTNM, M/O:, Type:CHAR, Size:60, Description:Department Name (DEPTCD) --> <xsd:element name="DEPTNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="PDEPTNM"> <xsd:sequence> - <!-- SEQ:80, Table:CMCTB_EMP_MDG/PDEPTNM, Field:SPRAS, M/O:, Type:VARC, Size:255, Description:Language Key (PDEPTCD) --> + <!-- SEQ:80, Table:CMCTB_EMP_MDG/PDEPTNM, Field:SPRAS, M/O:, Type:CHAR, Size:1, Description:Language Key (PDEPTCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:81, Table:CMCTB_EMP_MDG/PDEPTNM, Field:DEPTNM, M/O:, Type:VARC, Size:255, Description:Department Name (PDEPTCD) --> + <!-- SEQ:81, Table:CMCTB_EMP_MDG/PDEPTNM, Field:DEPTNM, M/O:, Type:CHAR, Size:60, Description:Department Name (PDEPTCD) --> <xsd:element name="DEPTNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="COMPNM"> <xsd:sequence> - <!-- SEQ:82, Table:CMCTB_EMP_MDG/COMPNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (COMPCD) --> + <!-- SEQ:82, Table:CMCTB_EMP_MDG/COMPNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (COMPCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:83, Table:CMCTB_EMP_MDG/COMPNM, Field:COMPNM, M/O:, Type:VARC, Size:255, Description:Company Name (COMPCD) --> + <!-- SEQ:83, Table:CMCTB_EMP_MDG/COMPNM, Field:COMPNM, M/O:, Type:CHAR, Size:60, Description:Company Name (COMPCD) --> <xsd:element name="COMPNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="CORPNM"> <xsd:sequence> - <!-- SEQ:84, Table:CMCTB_EMP_MDG/CORPNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (CORPCD) --> + <!-- SEQ:84, Table:CMCTB_EMP_MDG/CORPNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (CORPCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:85, Table:CMCTB_EMP_MDG/CORPNM, Field:CORPNM, M/O:, Type:VARC, Size:255, Description:Corporate Name (CORPCD) --> + <!-- SEQ:85, Table:CMCTB_EMP_MDG/CORPNM, Field:CORPNM, M/O:, Type:CHAR, Size:60, Description:Corporate Name (CORPCD) --> <xsd:element name="CORPNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="GNNM"> <xsd:sequence> - <!-- SEQ:86, Table:CMCTB_EMP_MDG/GNNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (GNCD) --> + <!-- SEQ:86, Table:CMCTB_EMP_MDG/GNNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (GNCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:87, Table:CMCTB_EMP_MDG/GNNM, Field:GNNM, M/O:, Type:VARC, Size:255, Description:General Name (GNCD) --> + <!-- SEQ:87, Table:CMCTB_EMP_MDG/GNNM, Field:GNNM, M/O:, Type:CHAR, Size:60, Description:General Name (GNCD) --> <xsd:element name="GNNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="BINM"> <xsd:sequence> - <!-- SEQ:88, Table:CMCTB_EMP_MDG/BINM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (BICD) --> + <!-- SEQ:88, Table:CMCTB_EMP_MDG/BINM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (BICD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:89, Table:CMCTB_EMP_MDG/BINM, Field:BINM, M/O:, Type:VARC, Size:255, Description:Business Place Name (BICD) --> + <!-- SEQ:89, Table:CMCTB_EMP_MDG/BINM, Field:BINM, M/O:, Type:CHAR, Size:60, Description:Business Place Name (BICD) --> <xsd:element name="BINM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="KTLNM"> <xsd:sequence> - <!-- SEQ:90, Table:CMCTB_EMP_MDG/KTLNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (KTL_EMP) --> + <!-- SEQ:90, Table:CMCTB_EMP_MDG/KTLNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (KTL_EMP) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:91, Table:CMCTB_EMP_MDG/KTLNM, Field:LTEXT, M/O:, Type:VARC, Size:255, Description:Cost Center (KTL_EMP) --> + <!-- SEQ:91, Table:CMCTB_EMP_MDG/KTLNM, Field:LTEXT, M/O:, Type:CHAR, Size:40, Description:Cost Center (KTL_EMP) --> <xsd:element name="LTEXT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="BANM"> <xsd:sequence> - <!-- SEQ:92, Table:CMCTB_EMP_MDG/BANM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (BIZAREA) --> + <!-- SEQ:92, Table:CMCTB_EMP_MDG/BANM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (BIZAREA) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:93, Table:CMCTB_EMP_MDG/BANM, Field:GTEXT, M/O:, Type:VARC, Size:255, Description:Business area description --> + <!-- SEQ:93, Table:CMCTB_EMP_MDG/BANM, Field:GTEXT, M/O:, Type:CHAR, Size:30, Description:Business area description --> <xsd:element name="GTEXT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="COUNTRYNM"> <xsd:sequence> - <!-- SEQ:94, Table:CMCTB_EMP_MDG/COUNTRYNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (COUNTRYCD) --> + <!-- SEQ:94, Table:CMCTB_EMP_MDG/COUNTRYNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (COUNTRYCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:95, Table:CMCTB_EMP_MDG/COUNTRYNM, Field:COUNTRYNM, M/O:, Type:VARC, Size:255, Description:Country Name (COUNTRYCD) --> + <!-- SEQ:95, Table:CMCTB_EMP_MDG/COUNTRYNM, Field:COUNTRYNM, M/O:, Type:CHAR, Size:60, Description:Country Name (COUNTRYCD) --> <xsd:element name="COUNTRYNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="JOBNM"> <xsd:sequence> - <!-- SEQ:96, Table:CMCTB_EMP_MDG/JOBNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (JOBCD) --> + <!-- SEQ:96, Table:CMCTB_EMP_MDG/JOBNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (JOBCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:97, Table:CMCTB_EMP_MDG/JOBNM, Field:JOBNM, M/O:, Type:VARC, Size:255, Description:Job Name (JOBCD) --> + <!-- SEQ:97, Table:CMCTB_EMP_MDG/JOBNM, Field:JOBNM, M/O:, Type:CHAR, Size:60, Description:Job Name (JOBCD) --> <xsd:element name="JOBNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="JOBDUTYNM"> <xsd:sequence> - <!-- SEQ:98, Table:CMCTB_EMP_MDG/JOBDUTYNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (JOBDUTYCD) --> + <!-- SEQ:98, Table:CMCTB_EMP_MDG/JOBDUTYNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (JOBDUTYCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:99, Table:CMCTB_EMP_MDG/JOBDUTYNM, Field:JOBDUTYNM, M/O:, Type:VARC, Size:255, Description:Job Duty Name (JOBDUTYCD) --> + <!-- SEQ:99, Table:CMCTB_EMP_MDG/JOBDUTYNM, Field:JOBDUTYNM, M/O:, Type:CHAR, Size:60, Description:Job Duty Name (JOBDUTYCD) --> <xsd:element name="JOBDUTYNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="JOBGRDNM"> <xsd:sequence> - <!-- SEQ:100, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (JOBGRDCD) --> + <!-- SEQ:100, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (JOBGRDCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:101, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:JOBGRDNM, M/O:, Type:VARC, Size:255, Description:Job Grade Name (JOBGRDCD) --> + <!-- SEQ:101, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:JOBGRDNM, M/O:, Type:CHAR, Size:60, Description:Job Grade Name (JOBGRDCD) --> <xsd:element name="JOBGRDNM" type="xsd:string" minOccurs="0"/> - <!-- SEQ:102, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:JOBGRDTYPE, M/O:, Type:VARC, Size:255, Description:Job Grade Type --> + <!-- SEQ:102, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:JOBGRDTYPE, M/O:, Type:CHAR, Size:1, Description:Job Grade Type --> <xsd:element name="JOBGRDTYPE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:103, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:ISEXECUT, M/O:, Type:VARC, Size:255, Description:Executive Indicator --> + <!-- SEQ:103, Table:CMCTB_EMP_MDG/JOBGRDNM, Field:ISEXECUT, M/O:, Type:CHAR, Size:1, Description:Executive Indicator --> <xsd:element name="ISEXECUT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ORGDEPTNM"> <xsd:sequence> - <!-- SEQ:104, Table:CMCTB_EMP_MDG/ORGDEPTNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (ORGDEPTCD) --> + <!-- SEQ:104, Table:CMCTB_EMP_MDG/ORGDEPTNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (ORGDEPTCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:105, Table:CMCTB_EMP_MDG/ORGDEPTNM, Field:DEPTNM, M/O:, Type:VARC, Size:255, Description:Department Name (ORGDEPTCD) --> + <!-- SEQ:105, Table:CMCTB_EMP_MDG/ORGDEPTNM, Field:DEPTNM, M/O:, Type:CHAR, Size:60, Description:Department Name (ORGDEPTCD) --> <xsd:element name="DEPTNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ORGPDEPNM"> <xsd:sequence> - <!-- SEQ:106, Table:CMCTB_EMP_MDG/ORGPDEPNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (ORGPDEPCD) --> + <!-- SEQ:106, Table:CMCTB_EMP_MDG/ORGPDEPNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (ORGPDEPCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:107, Table:CMCTB_EMP_MDG/ORGPDEPNM, Field:DEPTNM, M/O:, Type:VARC, Size:255, Description:Department Name (ORGPDEPCD) --> + <!-- SEQ:107, Table:CMCTB_EMP_MDG/ORGPDEPNM, Field:DEPTNM, M/O:, Type:CHAR, Size:60, Description:Department Name (ORGPDEPCD) --> <xsd:element name="DEPTNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ORGCOMPNM"> <xsd:sequence> - <!-- SEQ:108, Table:CMCTB_EMP_MDG/ORGCOMPNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (ORGCOMPCD) --> + <!-- SEQ:108, Table:CMCTB_EMP_MDG/ORGCOMPNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (ORGCOMPCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:109, Table:CMCTB_EMP_MDG/ORGCOMPNM, Field:COMPNM, M/O:, Type:VARC, Size:255, Description:Company Name (ORGCOMPCD) --> + <!-- SEQ:109, Table:CMCTB_EMP_MDG/ORGCOMPNM, Field:COMPNM, M/O:, Type:CHAR, Size:60, Description:Company Name (ORGCOMPCD) --> <xsd:element name="COMPNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ORGCORPNM"> <xsd:sequence> - <!-- SEQ:110, Table:CMCTB_EMP_MDG/ORGCORPNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (ORGCORPCD) --> + <!-- SEQ:110, Table:CMCTB_EMP_MDG/ORGCORPNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (ORGCORPCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:111, Table:CMCTB_EMP_MDG/ORGCORPNM, Field:CORPNM, M/O:, Type:VARC, Size:255, Description:Corporate Name (ORGCORPCD) --> + <!-- SEQ:111, Table:CMCTB_EMP_MDG/ORGCORPNM, Field:CORPNM, M/O:, Type:CHAR, Size:60, Description:Corporate Name (ORGCORPCD) --> <xsd:element name="CORPNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="ORGBICDNM"> <xsd:sequence> - <!-- SEQ:112, Table:CMCTB_EMP_MDG/ORGBICDNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (ORGBICD) --> + <!-- SEQ:112, Table:CMCTB_EMP_MDG/ORGBICDNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (ORGBICD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:113, Table:CMCTB_EMP_MDG/ORGBICDNM, Field:BINM, M/O:, Type:VARC, Size:255, Description:Business Place Name (ORGBICD) --> + <!-- SEQ:113, Table:CMCTB_EMP_MDG/ORGBICDNM, Field:BINM, M/O:, Type:CHAR, Size:60, Description:Business Place Name (ORGBICD) --> <xsd:element name="BINM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="OKTLNM"> <xsd:sequence> - <!-- SEQ:114, Table:CMCTB_EMP_MDG/OKTLNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (OKTL_EMPL) --> + <!-- SEQ:114, Table:CMCTB_EMP_MDG/OKTLNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (OKTL_EMPL) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:115, Table:CMCTB_EMP_MDG/OKTLNM, Field:LTEXT, M/O:, Type:VARC, Size:255, Description:Cost Center (OKTL_EMPL) --> + <!-- SEQ:115, Table:CMCTB_EMP_MDG/OKTLNM, Field:LTEXT, M/O:, Type:CHAR, Size:40, Description:Cost Center (OKTL_EMPL) --> <xsd:element name="LTEXT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="DHJOBGDNM"> <xsd:sequence> - <!-- SEQ:116, Table:CMCTB_EMP_MDG/DHJOBGDNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (DHJOBGDCD) --> + <!-- SEQ:116, Table:CMCTB_EMP_MDG/DHJOBGDNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (DHJOBGDCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:117, Table:CMCTB_EMP_MDG/DHJOBGDNM, Field:JOBGRDNM, M/O:, Type:VARC, Size:255, Description:Job Grade Name (DHJOBGDCD) --> + <!-- SEQ:117, Table:CMCTB_EMP_MDG/DHJOBGDNM, Field:JOBGRDNM, M/O:, Type:CHAR, Size:60, Description:Job Grade Name (DHJOBGDCD) --> <xsd:element name="JOBGRDNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="GJOBNM"> <xsd:sequence> - <!-- SEQ:118, Table:CMCTB_EMP_MDG/GJOBNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (GJOBCD) --> + <!-- SEQ:118, Table:CMCTB_EMP_MDG/GJOBNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (GJOBCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> + <!-- SEQ:119, Table:CMCTB_EMP_MDG/GJOBNM, Field:GJOBNM, M/O:, Type:CHAR, Size:20, Description:Global Job Name --> <xsd:element name="GJOBNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="GJOBDUTYNM"> <xsd:sequence> - <!-- SEQ:120, Table:CMCTB_EMP_MDG/GJOBDUTYNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (GJOBDUTYCD) --> + <!-- SEQ:120, Table:CMCTB_EMP_MDG/GJOBDUTYNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (GJOBDUTYCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:121, Table:CMCTB_EMP_MDG/GJOBDUTYNM, Field:GJOBDUTYNM, M/O:, Type:VARC, Size:255, Description:Global Job Duty Name --> + <!-- SEQ:121, Table:CMCTB_EMP_MDG/GJOBDUTYNM, Field:GJOBDUTYNM, M/O:, Type:CHAR, Size:21, Description:Global Job Duty Name --> <xsd:element name="GJOBDUTYNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="GJOBGRDNM"> <xsd:sequence> - <!-- SEQ:122, Table:CMCTB_EMP_MDG/GJOBGRDNM, Field:SPRAS, M/O:M, Type:VARC, Size:255, Description:Language Key (GJOBGRDCD) --> + <!-- SEQ:122, Table:CMCTB_EMP_MDG/GJOBGRDNM, Field:SPRAS, M/O:M, Type:CHAR, Size:1, Description:Language Key (GJOBGRDCD) --> <xsd:element name="SPRAS" type="xsd:string" minOccurs="0"/> - <!-- SEQ:123, Table:CMCTB_EMP_MDG/GJOBGRDNM, Field:GJOBGRDNM, M/O:, Type:VARC, Size:255, Description:Global Job Grade Name --> + <!-- SEQ:123, Table:CMCTB_EMP_MDG/GJOBGRDNM, Field:GJOBGRDNM, M/O:, Type:CHAR, Size:21, Description:Global Job Grade Name --> <xsd:element name="GJOBGRDNM" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> <xsd:complexType name="GJOBGRDTYPE"> <xsd:sequence> - <!-- SEQ:124, Table:CMCTB_EMP_MDG/GJOBGRDTYPE, Field:JOBGRDTYPE, M/O:, Type:VARC, Size:255, Description:Job Grade Type --> + <!-- SEQ:124, Table:CMCTB_EMP_MDG/GJOBGRDTYPE, Field:JOBGRDTYPE, M/O:, Type:CHAR, Size:1, Description:Job Grade Type --> <xsd:element name="JOBGRDTYPE" type="xsd:string" minOccurs="0"/> - <!-- SEQ:125, Table:CMCTB_EMP_MDG/GJOBGRDTYPE, Field:ISEXECUT, M/O:, Type:VARC, Size:255, Description:Executive Indicator --> + <!-- SEQ:125, Table:CMCTB_EMP_MDG/GJOBGRDTYPE, Field:ISEXECUT, M/O:, Type:CHAR, Size:1, Description:Executive Indicator --> <xsd:element name="ISEXECUT" type="xsd:string" minOccurs="0"/> </xsd:sequence> </xsd:complexType> |