...
| Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|
| kfsProjCode | KFS Project Number | Yes | String(10) | '1234567890' |
DB Query
| Code Block |
|---|
SELECT p.PROJECT_CD, 'true' AS VALIDPROJ_ACTIVE_CD FROM dwhs_ods..ca_project_t p WHERE p.proj_active_cdWHERE PROJ_ACTIVE_CD <> 'N' and p.PROJECT_CD inIN ('<kfsProjectCode>'); |
Result Schema: A list of following elements (ProjectValidation.java)
...